[Koha-bugs] [Bug 15240] New: Performance issue running overdue_notices.pl

[bugzilla-daemon at bugs.koha-community.org]

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.