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

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Daniel Kinzler <dan...@brightbyte.de>
Date: Sun, 06 Jan 2008 14:16:01
-------------------------------------------------------------------------------

The result is at <http://tools.wikimedia.de/~daniel/misc/shortpages-enwiki.txt>
(39441), details at
<http://wiki.ts.wikimedia.org/view/Query_service/short_pages_enwiki>.

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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to