http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15107 Bug ID: 15107 Summary: Batch Patron Deletion (Trash) Performance Improvement Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: cnorthcott.work@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Blocks: 7923 Batch Patron Deletion (Trash) has a fairly long run/load time compared to Batch Patron Deletion (Permanent). I have attempted to improve the runtime of the Batch Patron Deletion (Trash) tool and my enhancement reduces the time to modify a batch of patrons by an average of 78.21% I discovered the extended runtime was mostly due to the overhead DBIx::Class::ResultSet which I switched to basic SQL calls to the $dbh which reduced the trashing of 1000 patrons from 24.84 seconds to 5.41 seconds, saving 19.43 seconds of resultset calls. Referenced Bugs: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7923 [Bug 7923] Performance omnibus -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.