http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15240
Kyle M Hall <k...@bywatersolutions.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |k...@bywatersolutions.com
--- Comment #14 from Kyle M Hall <k...@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.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
