[Toolserver-l] SQL queries

[Ja Ga]

I was investigating a better version of Special:Lonelypages (ignore disambig pages, exclude the already tagged, identify 1- and 2- link orphans as well as no-link orphans, etc.) but when I run the original Lonelypages SQL query on nightshade against enwiki_p it times out after 10 minutes.

SELECT page_namespace, page_title FROM page LEFT JOIN pagelinks ON page_namespace=pl_namespace AND page_title=pl_title WHERE pl_namespace IS NULL AND page_namespace=".NS_MAIN." AND page_is_redirect=0;

I know pagelinks is HUGE (like 265,000,000+ entries), but I thought it would work since it's what we use for Lonelypages.  I'm looking at LIMIT queries, etc., but before I go further, is this just too much to ask of nightshade?

- Jason



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20081125/5db60d9f/attachment.htm