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