[Koha-bugs] [Bug 13740] New: Timeout on deleting patrons if too many patrons

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

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

            Bug ID: 13740
           Summary: Timeout on deleting patrons if too many patrons
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: ASSIGNED
          Severity: normal
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: jonathan.druart at biblibre.com
          Reporter: jonathan.druart at biblibre.com
        QA Contact: testopia at bugs.koha-community.org

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

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