[Koha-bugs] [Bug 17783] New: Optimize Koha::IssuingRules->get_effective_issuing_rule

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Dec 15 16:04:49 CET 2016


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17783

            Bug ID: 17783
           Summary: Optimize
                    Koha::IssuingRules->get_effective_issuing_rule
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: gmcharlt at gmail.com
          Reporter: lari.taskula at jns.fi
        QA Contact: testopia at bugs.koha-community.org

Koha::IssuingRules->get_effective_issuing_rule() seems to be making 8 different
queries in worst case scenario. The behavior is inherited from the old
C4::Circulation::GetIssuingRule().

Instead, a faster solution is to get the effective issuing rule with one single
query by sorting and limiting the result appropriately. This will make a
significant improvement in performance in situations where issuing rules need
to be requested multiple times.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list