--- Comment #18 from Roan Kattouw <> 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:
------- You are receiving this mail because: -------
You are on the CC list for the bug.

Wikibugs-l mailing list

Reply via email to