Is it possible to locally create some indexes specific for toolserver? As for now, it will help to seriously speed up most tools. E.g. index (rev_user,rev_page) will speed up all editcounters, which usually uses query like SELECT COUNT(*), page_namespace FROM page JOIN revision ON page_id = rev_page WHERE rev_user = 37880 GROUP BY page_namespace ORDER BY page_namespace;
Any ideas whether it would be possible and how useful would it be? --vvv _______________________________________________ Toolserver-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/toolserver-l
