Posted in: Newspaper
Post count: 4
Dec 16, 2024 at 12:31 pm
I used a theme that worked fine when the number of posts was in the hundreds. However, my website now has around 400,000 posts, and queries have become very slow.
After logging the slow queries, I found one like this:
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (641, 644, 645, …)
The IN clause in this query includes around 200,000 post_ids, and it takes about 100 seconds to complete.
Do you have any recommendations to address this issue? Please guide me. Thank you.
Post count: 27744
Dec 17, 2024 at 8:39 am
Hello,
Please get in touch with us via email at contact@tagdiv.com and provide the wp-admin and cPanel access.
Thank you!
Viewing 2 posts - 1 through 2 (of 2 total)
The forum ‘Newspaper’ is closed to new topics and replies.
