[Koha-bugs] [Bug 17941] CanBookBeRenewed is very inefficient/slow

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Feb 7 12:01:17 CET 2017


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

--- Comment #9 from Petter Goksøyr Åsen <boutrosboutrosboutros at gmail.com> ---
Some adittional evidence from testings Fransesco's patch:

Here are the stats of cache hits/misses from one call to /svc/checkouts (on a
patron with 5 checkouts, 2 of them which has many holds)

                                              hit   miss
C4::Circulation::GetBranchItemRule            4537  21
C4::Reserves::_OnShelfHoldsAllowed            13    116
C4::Reserves::IsAvailableForItemLevelRequest  0     129
C4::Circulation::CanBookBeRenewed             0     5
C4::Items::GetItem                            4845  33
C4::Members::GetMember                        4075  584
C4::Reserves::CheckReserves                   0     53
C4::Reserves::CanItemBeReserved               0     129
C4::Reserves::IsItemOnHoldAndFound            24    239

As you can see, we save almost 15 thousand DB-queries here!

We are most probably pushing this into production today.

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


More information about the Koha-bugs mailing list