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@lists.koha-community.org Reporter: pasi.kallinen@joensuu.fi QA Contact: testopia@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.