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)
committerNick Clemens <nick@bywatersolutions.com>
Sat, 15 Sep 2018 21:21:45 +0000 (21:21 +0000)
commitcb406f72b0266c97ac904754cc9637035000f5ca
tree833dcb52376f64593aa2e3fe422f163f8abb0591
parenta6f8eac4edb6463d8ff16928d6f2cddcf4dfbfc2
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>
installer/data/mysql/atomicupdate/bug_21288.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql