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@gmail.com Reporter: sophie.meynieux@biblibre.com QA Contact: testopia@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.