[Koha-bugs] [Bug 21288] Slowness in acquisition caused by GetInvoices
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Sat Sep 15 18:41:07 CEST 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21288
Chris Cormack <chris at bigballofwax.co.nz> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #78708|0 |1
is obsolete| |
--- Comment #5 from Chris Cormack <chris at bigballofwax.co.nz> ---
Created attachment 78856
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=78856&action=edit
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 at joensuu.fi>
Signed-off-by: Mark Tompsett <mtompset at hotmail.com>
Signed-off-by: Chris Cormack <chris at bigballofwax.co.nz>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list