Attachment 38937 Details for Bug 14132 – [SIGNED-OFF] Bug 14132: suggestions table is missing indexes

[patch] [SIGNED-OFF] Bug 14132: suggestions table is missing indexes

SIGNED-OFF-Bug-14132-suggestions-table-is-missing-.patch (text/plain), 1.53 KB, created by Bernardo Gonzalez Kriegel on 2015-05-06 23:09:17 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Bernardo Gonzalez Kriegel

Created: 2015-05-06 23:09:17 UTC

Size: 1.53 KB

patch

obsolete

>From 2794d04cab12d72216b3c72dbf743d430947e2cd Mon Sep 17 00:00:00 2001
>From: Fridolin Somers <fridolin.somers@biblibre.com>
>Date: Mon, 4 May 2015 13:35:07 +0200
>Subject: [PATCH] [SIGNED-OFF] 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 <bgkriegel@gmail.com>
>---
> installer/data/mysql/kohastructure.sql |    3 +++
> 1 file changed, 3 insertions(+)
>
>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.9.5

Actions: View | Diff | Splinter Review

Attachments on bug 14132: 38806 | 38807 | 38841 | 38842 | 38937 | 38938 | 38975 | 38976