https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35357
--- Comment #25 from Victor Grousset/tuxayo <[email protected]> --- (In reply to Kyle M Hall from comment #22) > Using DBIC to find and delete the lines in the two tables will result in 4 > queries compared to the one query we have now. The manual query should still do in practice two lookups via itemnumber. And then two deletes. But maybe for simple queries the overhead of doing individual queries is larger than the work done by the simple queries themselves. I don't know enough about real world DBMS behavior. --- (In reply to Katrin Fischer from comment #23) > Hi Kyle, can you explain a bit more about those extra queries if you can? > I'd like to understand the issue better and learn. IIUC, we don't have the ORM objects on hand so we have to do a find first. Then do a delete on the object. So 4 queries. (maybe Kyle had something else in mind) --- (In reply to Fridolin Somers from comment #24) > Seeing comments, I wait for backport No worries, you can backport. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
