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

Aaron Schulz <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #2 from Aaron Schulz <[email protected]> ---
It might also have to use SELECT 1 ... LIMIT X where X is some reasonable
number to short-circuit the query.

Alternatively, one could page through them for the count (if this is for a
population script). BacklinkCache::partition() already does that. Since
maintenance scripts turn of DBO_TRX, each paging query would be a separate
implicit server-side TRX, so row purging could happen in between each SELECT()
unlike the huge COUNT(*) SELECT now.

-- 
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to