https://bugzilla.wikimedia.org/show_bug.cgi?id=56840
Gabriel Wicke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #14 from Gabriel Wicke <[email protected]> --- 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
