[Koha-bugs] [Bug 15240] Performance issue running overdue_notices.pl

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

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

Kyle M Hall <kyle at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |kyle at bywatersolutions.com

--- Comment #14 from Kyle M Hall <kyle at bywatersolutions.com> ---
Pre patch:

time misc/cronjobs/overdue_notices.pl -t -itemscontent
title,author,itemcallnumber,barcode,replacementprice

real    2m9.252s
user    2m5.492s
sys     0m0.108s

Post Patch:

time misc/cronjobs/overdue_notices.pl -t -itemscontent
title,author,itemcallnumber,barcode,replacementprice

real    1m19.965s
user    1m12.437s
sys     0m0.192s

mysql> select COUNT(*) from issues where date_due > now();
+----------+
| COUNT(*) |
+----------+
|      480 |
+----------+
1 row in set (0.01 sec)

mysql> select COUNT(*) from issues where date_due <= now();
+----------+
| COUNT(*) |
+----------+
|    65218 |
+----------+
1 row in set (0.01 sec)

I found it quite striking how much of a time difference there was even though
the number of checkouts not due yet is quite low so I ran the tests again with
very similar results!

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