https://bugzilla.wikimedia.org/show_bug.cgi?id=24479
--- Comment #18 from Roan Kattouw <roan.katt...@gmail.com> 2010-12-31 20:12:02 UTC --- (In reply to comment #11) > (Of course, the query isn't scalable anyway due to COUNT(). It will have to > scan arbitrarily many rows. The only way to fully fix it would be to use a > summary table of some kind, but those are a pain to maintain, so better not to > do that unless you can't fix it some other way. It's not like we're going to > have 100 million code reviews anytime soon.) Yes, the COUNT() should be killed. Its results aren't displayed in trunk anymore anyway. The point about the code_rev table being smallish is also true, that's why these queries aren't much of a problem in practice. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- 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