[Koha-bugs] [Bug 14053] Acquisition db tables are missing indexes

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14053

--- Comment #11 from Fridolin SOMERS <fridolyn.somers at biblibre.com> ---
Created attachment 39135
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=39135&action=edit
Bug 14053 - Acquisition db tables are missing indexes

Acquisition db tables are missing some indexes to have performance queries.
This patch adds an index on some columns very often used in search queries,
such as aqbooksellers.name and aqbudgets.budget_code.
Also adds an index on aqorders.orderstatus, very often used with hardcoded
value like 'cancelled', in various queries.

Test plan :
 - Check SQL syntax is correct
 - Try to compare performance after and before database update. I think query
contained in C4::Acquistion::GetInvoices could be a good example

-- 
You are receiving this mail because:
You are watching all bug changes.