[Koha-bugs] [Bug 15240] New: Performance issue running overdue_notices.pl
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Nov 23 14:22:53 CET 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15240
Bug ID: 15240
Summary: Performance issue running overdue_notices.pl
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: critical
Priority: P5 - low
Component: Tools
Assignee: gmcharlt at gmail.com
Reporter: sophie.meynieux at biblibre.com
QA Contact: testopia at bugs.koha-community.org
Since introduction of
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12529#add_comment
"Overdue notices respect holidays" feature, there is a big problem of
performance running overdue_notices.pl
For one of our client, where it used to take less than one hour, it now takes
more than 7 hours. And this should be rune every day...
This is due to date criteria that were removed from SQL queries, so all current
issues are parsed 3 times (once for each level of overdue) rather than just
overdue issues concerning one given level.
Dealing with holidays should be done before quering issues, so that date
criteria could be used.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list