[wp-trac] [WordPress Trac] #22074: Very Large Query that Crashes the whole My SQL and site

[WordPress Trac]

#22074: Very Large Query that Crashes the whole My SQL and site
----------------------------------------+--------------------
 Reporter:  adest                       |       Owner:
     Type:  enhancement                 |      Status:  new
 Priority:  normal                      |   Milestone:  3.6
Component:  Performance                 |     Version:  3.4.1
 Severity:  normal                      |  Resolution:
 Keywords:  has-patch needs-unit-tests  |
----------------------------------------+--------------------

Comment (by mikelopez):

 Replying to [comment:1 nacin]:
 > We'd have to see the rest of the query, but, that looks like some custom
 code which calls get_pages() with a very lengthy 'exclude' parameter. We
 could optimize it a bit with an IN, but it's still probably going to be a
 long query.

 A long IN query is still better (way better actually) than a long AND
 query.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/22074#comment:14>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software