WordPress.org

Make WordPress Core

Changes between Version 1 and Version 2 of Ticket #17998, comment 4


Ignore:
Timestamp:
08/01/11 13:27:50 (4 years ago)
Author:
brianlayman
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #17998, comment 4

    v1 v2  
    1 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 reduce the possible result set from tens of thousands of records (or more) to perhaps a dozen or two records. That's how it is faster, going minutes to milliseconds. 
     1Because 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 reduce the possible result set from tens of thousands of records (or more) to perhaps a dozen or two records. That's how it is faster, going minutes to milliseconds. With this routine called thousands of times in an upgrade, the improvement is multiplied many many times. 
    22 
    33The if statement is still required as plugins may have added additional per site tables.