[Toolserver-l] Local indexes

Victor Vasiliev vasilvv at gmail.com
Mon Sep 15 17:48:31 UTC 2008


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



More information about the Toolserver-l mailing list