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@gmail.com Reporter: lari.taskula@jns.fi QA Contact: testopia@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.