[Koha-bugs] [Bug 26424] Better performance of svc/checkouts

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

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

--- Comment #1 from Fridolin SOMERS <fridolin.somers at biblibre.com> ---
Created attachment 109850
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=109850&action=edit
Bug 26424: Better performance of svc/checkouts

Ajax script svc/checkouts display checkouts of a patron.
For each item, it fetches a Koha::ItemType object and a Koha::AuthorisedValues
object for location,ccode,lost and damaged.

For performance on huge number of checkouts :
Item types should be fetch once before the loop.
authorised values should call
Koha::AuthorisedValues->get_description_by_koha_field because it uses a cache.

Test plan :
1) Dont apply patch
2) Use sql to define some items lost and damaged
3) Look at checkouts table on a patron with a lot of checkouts
4) Apply patch
5) Look at checkouts table again and check info are the same :
record level item type, item type, location, collection, lost, damaged

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