Fork: 0
jryland / Import
Transfer to URL with SHA Find file
Newer
Older
Import / web / www.xiaofrog.com / wiki / maintenance / archives / patch-categorylinksindex.sql
@John Ryland John Ryland on 22 Dec 2020 325 bytes import old code from DELL-PC svn checkout from years ago
Raw Blame History 
-- 
-- patch-categorylinksindex.sql
-- 
-- Per bug 10280 / http://bugzilla.wikimedia.org/show_bug.cgi?id=10280
--
-- Improve enum continuation performance of the what pages belong to a category query
-- 

ALTER TABLE /*$wgDBprefix*/categorylinks
   DROP INDEX cl_sortkey,
   ADD INDEX cl_sortkey(cl_to, cl_sortkey, cl_from);