https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21288 --- Comment #1 from paxed <pasi.kallinen@joensuu.fi> --- Created attachment 78306 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=78306&action=edit Data for the query from MySQL Explain -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21288 paxed <pasi.kallinen@joensuu.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21288 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nick@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21288 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #78307|0 |1 is obsolete| | --- Comment #4 from M. Tompsett <mtompset@hotmail.com> --- Created attachment 78708 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=78708&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@joensuu.fi> Signed-off-by: Mark Tompsett <mtompset@hotmail.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21288 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #78708|0 |1 is obsolete| | --- Comment #5 from Chris Cormack <chris@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@joensuu.fi> Signed-off-by: Mark Tompsett <mtompset@hotmail.com> Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21288 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com Status|Pushed to Master |Pushed to Stable --- Comment #7 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Pushed to 18.05.x for 18.05.04 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21288 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Text to go in the|Warning: This update adds | release notes|an index to the | |subscriptions table and as | |such may be time-consuming | |at update time for users | |with a large number of rows | |in this table. | -- You are receiving this mail because: You are watching all bug changes.