https://bugzilla.wikimedia.org/show_bug.cgi?id=42614
Aaron Schulz <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #25 from Aaron Schulz <[email protected]> --- (In reply to comment #24) > 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. More work can be done to deal with that but this issue can be closed now. -- 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
