User Essentials

xF1 Add-on User Essentials 2.8.2

No permission to download
Q. Renames are slow
A. Try adding indexes to the following tables;
Code:
alter table xf_thread add index last_post_user_id  (last_post_user_id);
alter table xf_report add index last_modified_user_id (last_modified_user_id);
alter table xf_warning  add index warning_user_id (warning_user_id );
alter table xf_spam_cleaner_log add index applying_user_id (applying_user_id );
alter table xf_spam_cleaner_log add index user_id (user_id );

Q. Likes Given page is very slow.
A. Try adding the index:
Code:
ALTER TABLE `xf_liked_content` ADD INDEX `user_like_date` (`like_user_id` ASC, `like_date` DESC);