[Koha-bugs] [Bug 4331] Slow Response Times Switching To Acquisitions

[bugzilla-daemon at kohaorg.ec2.liblime.com]

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4331


Colin Campbell <colin.campbell at ptfs-europe.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|enhancement                 |major
           Priority|P5                          |PATCH-Sent




--- Comment #1 from Colin Campbell <colin.campbell at ptfs-europe.com>  2010-03-23 10:04:07 ---
The acq-home page displays the current commited and spent totals for budgets.
Both these operations require a calculation on the aqorders tables keyed by
budget_id these operations were slow as there is no index of aqorders by
budget. Patch adds one which removes the delay time.

Inspection of acqui-home.pl revealed that the script was making numerous db
calls and calculations to produce data which was then discarded ( budgets were
actually retrieved from the database twice!) Removed pointless processing.
Renamed anonymous variables. Separate patch cleans the cruft from acqui-home.pl




-- 
Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.