From 9c40037b0077b772ddd5691824de4a26fe8fc29a Mon Sep 17 00:00:00 2001 From: Jan Gerber Date: Thu, 22 Nov 2012 19:12:42 +0000 Subject: [PATCH] add index to image table to query by type this speeds up Special:MIMESearch and allows queries for all files of one type. Change-Id: I85715b0553a771ab88d9763ba921923551988bd0 --- includes/installer/MysqlUpdater.php | 1 + includes/installer/SqliteUpdater.php | 1 + maintenance/archives/patch-img_media_mime-index.sql | 4 ++++ maintenance/tables.sql | 2 ++ 4 files changed, 8 insertions(+) create mode 100644 maintenance/archives/patch-img_media_mime-index.sql diff --git a/includes/installer/MysqlUpdater.php b/includes/installer/MysqlUpdater.php index 9978a92322..d8fa64e3a1 100644 --- a/includes/installer/MysqlUpdater.php +++ b/includes/installer/MysqlUpdater.php @@ -229,6 +229,7 @@ class MysqlUpdater extends DatabaseUpdater { array( 'modifyField', 'user_groups', 'ug_group', 'patch-ug_group-length-increase-255.sql' ), array( 'modifyField', 'user_former_groups', 'ufg_group', 'patch-ufg_group-length-increase-255.sql' ), array( 'addIndex', 'page_props', 'pp_propname_page', 'patch-page_props-propname-page-index.sql' ), + array( 'addIndex', 'image', 'img_media_mime', 'patch-img_media_mime-index.sql' ), ); } diff --git a/includes/installer/SqliteUpdater.php b/includes/installer/SqliteUpdater.php index 47650b6b39..11e3445518 100644 --- a/includes/installer/SqliteUpdater.php +++ b/includes/installer/SqliteUpdater.php @@ -109,6 +109,7 @@ class SqliteUpdater extends DatabaseUpdater { array( 'modifyField', 'user_groups', 'ug_group', 'patch-ug_group-length-increase-255.sql' ), array( 'modifyField', 'user_former_groups', 'ufg_group', 'patch-ufg_group-length-increase-255.sql' ), array( 'addIndex', 'page_props', 'pp_propname_page', 'patch-page_props-propname-page-index.sql' ), + array( 'addIndex', 'image', 'img_media_mime', 'patch-img_media_mime-index.sql' ), ); } diff --git a/maintenance/archives/patch-img_media_mime-index.sql b/maintenance/archives/patch-img_media_mime-index.sql new file mode 100644 index 0000000000..bfaf84f9a6 --- /dev/null +++ b/maintenance/archives/patch-img_media_mime-index.sql @@ -0,0 +1,4 @@ +-- New index on image table to allow searches for types i.e. video webm +-- Added 2013-01-08 + +CREATE INDEX /*i*/img_media_mime ON /*_*/image (img_media_type,img_major_mime,img_minor_mime); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 4307c0c711..72b4eb6cfa 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -862,6 +862,8 @@ CREATE INDEX /*i*/img_size ON /*_*/image (img_size); CREATE INDEX /*i*/img_timestamp ON /*_*/image (img_timestamp); -- Used in API and duplicate search CREATE INDEX /*i*/img_sha1 ON /*_*/image (img_sha1(10)); +-- Used to get media of one type +CREATE INDEX /*i*/img_media_mime ON /*_*/image (img_media_type,img_major_mime,img_minor_mime); -- -- 2.20.1