• 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.