From 7e6ce52f2a5747cbd999a45e601ea190f2f5b045 Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Mon, 4 May 2015 13:35:07 +0200 Subject: [PATCH] [PASSED QA] Bug 14132: suggestions table is missing indexes Suggestions table is missing some indexes. Index on biblionumber will speed up C4::Suggestions::GetSuggestionInfoFromBiblionumber(), often called in a loop. Index on status and branchcode will speed up many queries. Note that an index on budgetid is automatically added by the creation of the foreign key constraint. Test plan : - Check performance with an invoice containing a lot of orders. - Check suggestions pages are faster or at least not slower. Signed-off-by: Bernardo Gonzalez Kriegel Signed-off-by: Kyle M Hall --- installer/data/mysql/kohastructure.sql | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index dd6bac9..9d3efed 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2203,6 +2203,9 @@ CREATE TABLE `suggestions` ( -- purchase suggestions PRIMARY KEY (`suggestionid`), KEY `suggestedby` (`suggestedby`), KEY `managedby` (`managedby`), + KEY `status` (`STATUS`), + KEY `biblionumber` (`biblionumber`), + KEY `branchcode` (`branchcode`), CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- 1.7.2.5