https://bugzilla.wikimedia.org/show_bug.cgi?id=56840
Nik Everett <neverett+bugzi...@wikimedia.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |neverett+bugzilla@wikimedia
| |.org
--- Comment #3 from Nik Everett <neverett+bugzi...@wikimedia.org> ---
You can probably make the query a lot faster by removing the offset and adding
a WHERE page_title > $last_title$. It changes the feature slightly but
iterating using something unique that you are sorted on and have indexed is
generally pretty quick and prevents the duplicates you can get with OFFSET
clauses. I think this is worth doing even if we don't want stuff crawling the
end point because it closes up a vector of attack.
--
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
