--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: Daniel Kinzler <>
Date: Sun, 06 Jan 2008 14:16:01

The result is at <>
(39441), details at

I used the original query, only cleaned it up a bit. I got rid of the first
subquery, but as it turns out, mysql was already smart enough to optimize it
away anyway.

@DaB: avoiding the second subquery at the cost of running a GROUP on all
revisions on enwiki probably makes things worse, not better. Running group on
such a huge table is expensive, and running a simple subquery on a set of
relatively few pages is probably faster - this is true because page_len < 50 is
a pretty strong limitation; if we had no such strong resatriction, grouping
would probably be faster.

You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to