Bug 21288: Slowness in acquisition caused by GetInvoices
authorPasi Kallinen <pasi.kallinen@joensuu.fi>
Thu, 30 Aug 2018 08:29:54 +0000 (11:29 +0300)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 17 Sep 2018 13:56:22 +0000 (14:56 +0100)
commit40536fedd39a0a22c3e93a00721b573d66392e09
treeb090da6ff92939b76ea1e6b8bb7e695b7a599810
parent06f0209840d290bb1a7340f4b1af8d55e932f7c1
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>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit cb406f72b0266c97ac904754cc9637035000f5ca)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
installer/data/mysql/atomicupdate/bug_21288.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql