WordPress.org

1. lorenzov
   Member
   Posted 3 weeks ago #

   I have an installation of Wp 2.8.4 with 20.000+ posts.
   SQL queries are getting slow, do you have any hints for optimization?

   Looking at mysql slow queries log I see a lot of sql commands that are taking many seconds to execute, here a few ones:

   SELECT SQL_CALC_FOUND_ROWS wp_sport_posts.* FROM wp_sport_posts WHERE 1=1 AND wp_sport_posts.post_type = 'post' AND (wp_sport_posts.post_status = 'publish') ORDER BY wp_sport_posts.post_date DESC LIMIT 0, 10;

   SELECT SQL_CALC_FOUND_ROWS wp_sport_posts.* FROM wp_sport_posts WHERE 1=1 AND wp_sport_posts.post_type = 'post' AND (wp_sport_posts.post_status = 'publish') ORDER BY wp_sport_posts.ID ASC LIMIT 0, 1;

2. MichaelH
   moderator
   Posted 3 weeks ago #

   Well I can at least point you to some recent trac discussions on this:

   http://core.trac.wordpress.org/ticket/10964
   http://core.trac.wordpress.org/ticket/10469

3. lorenzov
   Member
   Posted 3 weeks ago #

   thanks it helped a lot, but some queries are still slowing down the installation.
   Is anyone still working on optimizing those queries? I think lots of sites are experiencing the same issues and there's space for further improvements

4. MichaelH
   moderator
   Posted 3 weeks ago #

   Since both of those trac tickets are still open you might consider commenting on one or both about your experiences. Use your forum login/password at trac.

Reply

You must log in to post.