https://bugzilla.wikimedia.org/show_bug.cgi?id=56840
Gabriel Wicke <gwi...@wikimedia.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |gwi...@wikimedia.org
--- Comment #14 from Gabriel Wicke <gwi...@wikimedia.org> ---
Out of curiosity, do we actually know why the section query seems to touch all
pages? From what I can tell the offset is always <# of pages in wiki> / 100,
and the second >= page_title clause is incremented on each iteration. Maybe the
MySQL optimizer is not clever enough to figure out that it can drop the first
page_title clause:
(page_title >= '1887') AND (page_title >= 'Centennial_Trail_State_Park')
If that is the case, then changing the query to only use the second clause
should bring the complexity down to O(N) per page for O(N^2) total.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
