https://bugzilla.wikimedia.org/show_bug.cgi?id=60618
--- Comment #2 from Bawolff (Brian Wolff) <bawolff...@gmail.com> --- Removing the /*! STRAIGHT_JOIN */ would probably help as there is only 163 pages in the module namespace in commons (On tool labs, query without straight join took 0.16 seconds), so much more efficient to join the other way around. However that doesn't really help the general case of a template with millions of transclusions none of which are in the namespace being looked for, and that namespace also has millions of pages. I'm not sure if anything can help with that case short of duplicating the namespace of tl_from into template links table (Wouldn't it be nice if indexes could cross table boundaries?) ---- >https://commons.wikimedia.org/w/index.php?title=Special%3AWhatLinksHere&target=Module%3AFallbacklist&namespace=828 > If you really wanted to know, the modules that link to Fallbacklist are: +------------------+ | page_title | +------------------+ | File | | Coordinates | | Fallback | | Fallbacklist | | Fallbacklist/doc | | Coordinates/doc | | Fallback/sandbox | | File/doc | +------------------+ -- You are receiving this mail because: You are the assignee for the bug. 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