I keep getting a slow query warning for this:
wpForoAttachments->get_sizes()
Any ideas on how to resolve it?
Notifications
Clear all
Feb 06, 2021 7:18 pm
9 Replies
Feb 08, 2021 4:38 pm
Can anyone help with this?
Feb 09, 2021 10:25 am
Use your phpMyAdmin database manager and execute the SQL below. Make sure the wp_ table prefix is changed to your table prefix:
ALTER TABLE `wp_wpforo_attachments` ADD INDEX(`size`);
Feb 09, 2021 2:45 pm
@tomson Ok thanks Tom, Ill try, but im not too sure what you mean lol
I will look into it, I appreciate your help man thanks
Mar 18, 2021 12:36 am
@tomson Hi tom, I still havent done this as im scared i might break something, could you explain what Io have to do in a little more detail when you have time so i feel more comfortable doing it 🙂 I hate messing with databases
Mar 18, 2021 5:41 pm
The SQL command will add an index to wp_wpforo_attachments table > size field and make it faster. Just open your database with phpMyAdmin database manager, make sure your database table prefix is wp_ (if not, just change it) and execute the SQL query in the [SQL] tab.
Mar 18, 2021 5:48 pm
Mar 18, 2021 5:50 pm
Mar 18, 2021 8:05 pm
Just open your database with phpMyAdmin
I did that and then nothing makes sense lol
make sure your database table prefix is wp_ (if not, just change it) and execute the SQL query in the [SQL] tab.
can you explain this in more detail for a noob please mate lol
Mar 20, 2021 2:14 am
It adds a table index for 'size' field. It makes the counting of total attachments size many times faster. This will help make the wpForoAttachments->get_sizes() function (reported in your first post) to work faster.