Changes between Initial Version and Version 1 of Ticket #24837, comment 5
- Timestamp:
- 08/13/2013 01:04:56 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #24837, comment 5
initial v1 10 10 ) = 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 11 11 }}} 12 12 13 13 14 after 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)
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png)