https://bugzilla.wikimedia.org/show_bug.cgi?id=30758
Krinkle <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|Unprioritized |Low Status|NEW |RESOLVED Resolution| |FIXED Summary|Making for |Implement filtering host |Special:WantedTemplates |pages of |possible to (de-)select |Special:WantedTemplates by |namespaces |namespace Severity|normal |enhancement --- Comment #1 from Krinkle <[email protected]> 2011-09-05 00:18:24 UTC --- To clarify (after IRC conversation). Right now the slow (cached) background query works as following: * Get all templatelinks [1] * Filter only those that tranclude out of NS_TEMPLATE (ie. ignore {{:Article}}, or {{User:Foo/Bar}}) * Group rows that transclude the same template * Order by count The query does not have [1] information on what the title or namespace of the host page is. Even if it would know it (by doing an SQL JOIN), it would have nowhere to store it since the querycache table doesn't have space for that. If it would have space for it, it'd have to have a massive index to allow a live-filter on it. The only solution that isn't unacceptably slow is to have separate querycaches for Wantedtemplates for each namespace and then a cache for all namespaces together, which is quite insane. If there is a usecase for it, we might be able to come up with a better solution, but until then I'm marking this WONTFIX. If the data is needed only once or every once in a while, you may request the Toolserver users to perform the query for you in a long-running job and publish it for you to use. [2] -- Krinkle [1] the templatelinks table contains three columns: * namespace of page being trancluded (usually NS_TEMPLATE) * pagetitle of page being trancluded (ie. "Infobox") * pageid of host page calling the template (ie. the page doing {{Infobox}}). [2] - https://wiki.toolserver.org/view/Query_service - #wikimedia-toolserver (or me!) http://meta.wikimedia.org/wiki/User:Krinkle/Queries/ -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
