https://bugzilla.wikimedia.org/show_bug.cgi?id=56840
--- Comment #18 from Gabriel Wicke <gwi...@wikimedia.org> --- (In reply to comment #15) > I think it's actually the OFFSET clause (in this case, the first element of > the > LIMIT tuple) which is slowing things down. There isn't an effective index > that > can quickly give you the "86786th article after > Centennial_Trail_State_Park". > So instead it's sequentially scanning through 86,786 entries Yeah, that's 1/100 of 8.6 million pages. Very close to the nine million rows from the original report. > (and the offset grows the further you go). Are we sure that this is the case? My reading of the code suggests that it remains constant per wiki. -- 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
