https://bugzilla.wikimedia.org/show_bug.cgi?id=25799
--- Comment #7 from Krinkle <krinklem...@gmail.com> 2010-11-12 21:56:07 UTC ---
I found the query by the way:
// Get patrol statistics
$dbQuery = "
SELECT
count(*) AS counter,
log_action,
user_name,
user_registration,
user_editcount
FROM logging log
JOIN user us
ON log.log_user = us.user_id
WHERE log.log_type = 'patrol'
AND log.log_action = 'patrol'
AND log.log_params LIKE '%\n0' /* <-- this line */
GROUP BY log.log_user
ORDER BY counter DESC
LIMIT 50;";
So yeah, that's everything but effecient. The query run took little over 5-6
minutes.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- 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
