Bugzilla – Attachment 38806 Details for
Bug 14132
suggestions table is missing indexes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14132 - suggestions table is missing indexes
Bug-14132---suggestions-table-is-missing-indexes.patch (text/plain), 1.45 KB, created by
Fridolin Somers
on 2015-05-04 12:03:37 UTC
(
hide
)
Description:
Bug 14132 - suggestions table is missing indexes
Filename:
MIME Type:
Creator:
Fridolin Somers
Created:
2015-05-04 12:03:37 UTC
Size:
1.45 KB
patch
obsolete
>From 0dd38d192340cf86be389a44f9df43985832b992 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] 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. >--- > 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 39b3e08..4fd5573 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; > >-- >2.1.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14132
:
38806
|
38807
|
38841
|
38842
|
38937
|
38938
|
38975
|
38976