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