From ace6335e64b29ada7838938a2346d3cae3982c98 Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Tue, 21 Apr 2009 03:12:14 +0000 Subject: Add a key on item_id for the search_records table so that when we left join it against the item table to find missing ids it's fast. --- modules/search/helpers/search_installer.php | 1 + 1 file changed, 1 insertion(+) (limited to 'modules') diff --git a/modules/search/helpers/search_installer.php b/modules/search/helpers/search_installer.php index 46f92e83..c6591868 100644 --- a/modules/search/helpers/search_installer.php +++ b/modules/search/helpers/search_installer.php @@ -28,6 +28,7 @@ class search_installer { `dirty` boolean default 1, `data` LONGTEXT default NULL, PRIMARY KEY (`id`), + KEY(`item_id`), FULLTEXT INDEX (`data`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;"); -- cgit v1.2.3