[Koha-bugs] [Bug 21288] New: Slowness in acquisition caused by GetInvoices
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Aug 30 10:25:24 CEST 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21288
Bug ID: 21288
Summary: Slowness in acquisition caused by GetInvoices
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: P5 - low
Component: Acquisitions
Assignee: koha-bugs at lists.koha-community.org
Reporter: pasi.kallinen at joensuu.fi
QA Contact: testopia at bugs.koha-community.org
The SQL query done by GetInvoices is quite slow on our production server.
# Query_time: 55.436404 Lock_time: 0.000097 Rows_sent: 231 Rows_examined:
190484
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.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list