[Koha-bugs] [Bug 14057] Inventory is painfully slow

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14057

--- Comment #19 from Marc Véron <veron at veron.ch> ---
Created attachment 38636
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=38636&action=edit
[Signed-off] Bug 14057 - A Rough Start

This patch is a rough start. I believe it runs exponentially
faster, but its equality to the previous version needs to be
tested before I clean it up to acceptable standards.

Nested hashes of hashes was being a debugging nightmare.

Moved the SQL select to C4::Koha.

Changed the GetItemsForInventory to have a hashref parameter.
Added interface, in case there is a need for 'opac' vs. 'staff'.

Added t/db_dependent/Items/GetItemsForInventory.t
Added t/db_dependent/Koha/GetKohaAuthorisedValuesMapping.t

---
How I tested:
- Apply patch
- Do some full and some filtered Inventories, behaviour is the same (but faster
as without patch)
- Run both tests

Signed-off-by: Marc Véron <veron at veron.ch>

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