I keep getting a slow query warning for this:
wpForoAttachments->get_sizes()
Any ideas on how to resolve it?
Notifications
Clear all
Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed. We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
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.