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)
committerFridolin Somers <fridolin.somers@biblibre.com>
Mon, 24 Sep 2018 09:58:51 +0000 (11:58 +0200)
commit9ab177907cb0b568118770b5e9f7e5ffb0ffe54b
tree07401cecf958f0198eda278cb6eac6ea6b026c02
parentb610d6c95cec777c72f7c49f6ea281edb5862533
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>
(cherry picked from commit 40536fedd39a0a22c3e93a00721b573d66392e09)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/atomicupdate/bug_21288.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql