WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #24837, comment 5


Ignore:
Timestamp:
08/13/2013 01:04:56 PM (6 years ago)
Author:
robertv123
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #24837, comment 5

    initial v1  
    1010                                ) = 2 ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 20
    1111}}}
     12
    1213
    1314after I split it up into many queries that mysql can handle easier. My guess is mysql does not cache a sub queries result. This creates a temporary table (mysql could do this automatically but that's another story, sub queries are well known to be poor in mysql)