[Koha-bugs] [Bug 19792] Reduce number of SQL calls in GetBudgetHierarchy

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

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

--- Comment #17 from Nicolas Legrand <nicolas.legrand at bulac.fr> ---
I did a benchmark on a 16.11.00 with NYTProf, with and without the patch, with
GetBudgetHierarchy being called with arguments.

We have 517 aqbudgets lines.

acqui-home without 19792 ran in 19.5s, 4.83s is spent in GetBudgetHierarchy.
acqui-home with 19792 ran in 12.3s, 38.6ms is spent in GetBudgetHierarchy.

So it does improve our performances even when GetBudgetHierarchy is called
without arguments. I'll test monday on orderreceive which load
GetBudgetHierarchy with a budgetid.

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