[Koha-bugs] [Bug 13740] Timeout on deleting patrons if too many patrons
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Mar 13 19:07:22 CET 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13740
Kyle M Hall <kyle at bywatersolutions.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #36410|0 |1
is obsolete| |
Attachment #36411|0 |1
is obsolete| |
--- Comment #13 from Kyle M Hall <kyle at bywatersolutions.com> ---
Created attachment 36873
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=36873&action=edit
[PASSED QA] Bug 13740: Remove the NOT NULL clause in GetBorrowersToExpunge
C4::Borrowers::GetBorrowersToExpunge should not use a "NOT IN", it is
not efficient at all.
With only 1 guarantor and more than 136k patrons, the not in clause in
this subroutine takes ages:
mysql> select count(*) FROM borrowers where borrowernumber NOT IN
(SELECT guarantorid FROM borrowers WHERE guarantorid IS NOT NULL AND
guarantorid <> 0) ;
[...]
not ended after 5min
With the query modified by this patch, the results come after 1 sec :)
Test plan:
Verify the delete_patrons.pl cronjob or the cleanborrowers tools work as
before.
Especially with guarantors.
Signed-off-by: Brendan Gallagher <brendan at bywatersolutions.com>
Signed-off-by: Koha Team AMU <koha.aixmarseille at gmail.com>
Signed-off-by: Kyle M Hall <kyle at bywatersolutions.com>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list