https://bugzilla.wikimedia.org/show_bug.cgi?id=56840
--- Comment #15 from C. Scott Ananian <canan...@wikimedia.org> --- 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 (and the offset grows the further you go). -- 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