Changes between Initial Version and Version 1 of Ticket #17998, comment 4
- Timestamp:
- 08/01/2011 01:22:53 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #17998, comment 4
initial v1 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 s the possible result set from tens of thousands of records or more to perhaps a dozen or two records.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. 2 2 3 3 The if statement is still required as plugins may have added additional per site tables.