get_pages query optimization for inclusions/exclusions
|Reported by:||5ubliminal||Owned by:|
Turned ID <> 1, ID <> 2, ... into ID IN (1, 2, ...).
Removed some redundant ->prepare as the IDs are already int-cast, hence improved performance.
Concatenation is done once also, not once for each excluded ID.
Shortened the query a lot and gained 20% in speed compared to old method (on about 25 excluded pages from about 40).
Change History (3)
- Keywords has-patch 3.4-early added
- Milestone changed from Awaiting Review to Future Release
- Type changed from task (blessed) to enhancement