[Koha-bugs] [Bug 26457] DB DeadLock when renewing checkout items

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

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

--- Comment #2 from David Cook <dcook at prosentient.com.au> ---
I suppose one option would be to do 1 AJAX request with all the information,
rather than 1 AJAX request for *each* issue.

That would probably cause a performance degradation overall though.

I suppose one obvious fix would be changing from

UPDATE issues SET date_due = ?, renewals = ?, lastreneweddate = ? WHERE
borrowernumber=? AND itemnumber=?"

to:

UPDATE issues SET date_due = ?, renewals = ?, lastreneweddate = ? WHERE
issue_id=?"

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