Summary: | Slowness in acquisition caused by GetInvoices | ||
---|---|---|---|
Product: | Koha | Reporter: | paxed <pasi.kallinen> |
Component: | Acquisitions | Assignee: | paxed <pasi.kallinen> |
Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
Severity: | minor | ||
Priority: | P5 - low | CC: | fridolin.somers, martin.renvoize, nick |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: | |||
Attachments: |
Data for the query from MySQL Explain
Bug 21288: Slowness in acquisition caused by GetInvoices Bug 21288: Slowness in acquisition caused by GetInvoices Bug 21288: Slowness in acquisition caused by GetInvoices |
Description
paxed
2018-08-30 08:25:24 UTC
Created attachment 78306 [details]
Data for the query from MySQL Explain
Created attachment 78307 [details] [review] Bug 21288: Slowness in acquisition caused by GetInvoices The SQL query done by GetInvoices is quite slow on our production server, taking about a minute. In the query, there's this join: LEFT JOIN subscription ON biblio.biblionumber = subscription.biblionumber but there's no index on subscription.biblionumber. Adding the index speeds up the query so it only takes up about 3 seconds. Very glad you reported and investigated this - we had quite some trouble with invoices search in one of our installations. Will try to test! Created attachment 78708 [details] [review] Bug 21288: Slowness in acquisition caused by GetInvoices The SQL query done by GetInvoices is quite slow on our production server, taking about a minute. In the query, there's this join: LEFT JOIN subscription ON biblio.biblionumber = subscription.biblionumber but there's no index on subscription.biblionumber. Adding the index speeds up the query so it only takes up about 3 seconds. Signed-off-by: Pasi Kallinen <pasi.kallinen@joensuu.fi> Signed-off-by: Mark Tompsett <mtompset@hotmail.com> Created attachment 78856 [details] [review] Bug 21288: Slowness in acquisition caused by GetInvoices The SQL query done by GetInvoices is quite slow on our production server, taking about a minute. In the query, there's this join: LEFT JOIN subscription ON biblio.biblionumber = subscription.biblionumber but there's no index on subscription.biblionumber. Adding the index speeds up the query so it only takes up about 3 seconds. Signed-off-by: Pasi Kallinen <pasi.kallinen@joensuu.fi> Signed-off-by: Mark Tompsett <mtompset@hotmail.com> Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz> Awesome work all! Pushed to master for 18.11 Pushed to 18.05.x for 18.05.04 Pushed to 17.11.x for 17.11.10 |