https://bugzilla.wikimedia.org/show_bug.cgi?id=42614

--- Comment #24 from Aaron Schulz <[email protected]> ---
I've always found the rows count for EXPLAIN to be useless since it never
accounts for LIMIT (unless something change recently). A lot of fast queries
(deeply paged history view_ look slow going of that number.

Technically ORDER BY is needed to make sure the DB is not always just getting
the top/bottom row. Testing around shows that this is the case. This will lead
to more races/retries for claiming rows. I'll see if there is some compromise
here.

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to