diff options
| author | Bharat Mediratta <bharat@menalto.com> | 2009-04-21 03:12:14 +0000 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2009-04-21 03:12:14 +0000 |
| commit | ace6335e64b29ada7838938a2346d3cae3982c98 (patch) | |
| tree | 9a94594018add3361bef8dc386038124361fdbe8 | |
| parent | e8ea822801fdb18942529ff15390e8a6de92a9a3 (diff) | |
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.
| -rw-r--r-- | modules/search/helpers/search_installer.php | 1 |
1 files changed, 1 insertions, 0 deletions
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;"); |