Context Navigation

Changes between Version 1 and Version 2 of 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.
	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. With this routine called thousands of times in an upgrade, the improvement is multiplied many many times.
2	2
3	3	The if statement is still required as plugins may have added additional per site tables.