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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Thu, 27 Jan 2011 15:38:07
-------------------------------------------------------------------------------

The first query needed 6m58.933s to execute, the second 1m12.616s.  
Further, the second only includes the page 2016, I don't know if that can be
true, but I couldn't find an error in my Queries ![][1]

SQL:  
(first query)

    SELECT page.page_title as page FROM langlinks INNER JOIN page on
langlinks.ll_from = page.page_id WHERE page.page_namespace = 0 GROUP BY ll_from
ORDER BY COUNT(*) DESC LIMIT 5000;


(second query)

    SELECT page.page_title as page FROM (SELECT * FROM langlinks INNER JOIN
page on langlinks.ll_from = page.page_id WHERE page.page_namespace = 0 GROUP BY
ll_from ORDER BY COUNT(*) DESC LIMIT 5000) as langlinks INNER JOIN page ON
langlinks.ll_from = page.page_id LEFT JOIN (SELECT COUNT(*) as bool, ll_from
FROM langlinks WHERE ll_lang = 'pt' GROUP BY ll_from) as tmp ON tmp.ll_from =
langlinks.ll_from WHERE isnull(tmp.bool);


Results:  
http://toolserver.org/~hoo/dbq/dbq-121.txt (first query)  
http://toolserver.org/~hoo/dbq/dbq-121_2.txt (second query)

   [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif

-- 
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