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
_______________________________________________
Toolserver-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
