[wp-trac] [WordPress Trac] #17998: New Site & Upgrade process uses unrestricted "show all" causing timeouts

[WordPress Trac]

#17998: New Site & Upgrade process uses unrestricted "show all" causing timeouts
-----------------------------------------+------------------------------
 Reporter:  brianlayman                  |       Owner:
     Type:  defect (bug)                 |      Status:  new
 Priority:  normal                       |   Milestone:  Awaiting Review
Component:  Database                     |     Version:  3.2
 Severity:  major                        |  Resolution:
 Keywords:  has-patch reporter-feedback  |
-----------------------------------------+------------------------------

Comment (by brianlayman):

 Because this routine is already called for each site.  Specifying a where
 clause that restricts the records to only those records likely to match
 the criteria in the if statement later in this routine, you reduces the
 possible result set from tens of thousands of records or more to perhaps a
 dozen or two records.

 The if statement is still required as plugins may have added additional
 per site tables.

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