Bug 14132: suggestions table is missing indexes
authorFridolin Somers <fridolin.somers@biblibre.com>
Mon, 4 May 2015 11:35:07 +0000 (13:35 +0200)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Thu, 14 May 2015 15:08:26 +0000 (12:08 -0300)
commit2ccecbe3ac308724ed7554592dcfbb93be76bd84
tree405df426b3b35de9f43a3e9aff3f972a603ded27
parent4be083803334321c48d6df5013f20e503274efc7
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>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
installer/data/mysql/kohastructure.sql