SELECT SQL_CALC_FOUND_ROWS problem
-
Hello,
first of all I’ll like to say that i used search on this and find a lot of topics here on https://www.remarpro.com and around the web, but all of them are outdated and related to old WP versions.So here’s my problem:
I have a WP installation with ~210 000 posts and 1000-1200unique daily visits.
I’m using super cache plugin but new posts are added every 5-6 minutes and the cache plugin is not very helpful,because it has to be removed(cache) almost every minute.Without the cache plugin my index page is loading around 6-7 seconds and I’ve noticed that the problem comes from this query:
Query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts...
For the test i removed 200 000 of the posts from the db and then reload the index – and it was loading for 0.2-0,5s
Does anyone know how to fix this?Thanks in advance for your help!
- The topic ‘SELECT SQL_CALC_FOUND_ROWS problem’ is closed to new replies.