http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13740 --- Comment #1 from Jonathan Druart <jonathan.druart@biblibre.com> --- Created attachment 36096 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=36096&action=edit 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. -- You are receiving this mail because: You are watching all bug changes.