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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
