http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4331 Colin Campbell <colin.campbell@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |major Priority|P5 |PATCH-Sent --- Comment #1 from Colin Campbell <colin.campbell@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.

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4331 --- Comment #3 from Colin Campbell <colin.campbell@ptfs-europe.com> 2010-03-23 10:06:48 --- Created an attachment (id=1756) --> (http://bugs.koha.org/cgi-bin/bugzilla3/attachment.cgi?id=1756) Patch removing useless processing from acq-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.

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4331 Colin Campbell <colin.campbell@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED -- 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.