[Koha-bugs] [Bug 35357] Item not removed from holds queue when checked out to a different patron

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35357

--- Comment #25 from Victor Grousset/tuxayo <victor at tuxayo.net> ---
(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.