[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

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

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

--- Comment #11 from Srdjan Jankovic <srdjan at catalyst.net.nz> ---
Kyle, I'm afraid DELETE FROM patronimage WHERE cardnumber NOT IN ( SELECT
cardnumber FROM borrowers ) is not good. Logically it is ok, however the number
of borrowers can be so huge that it will use heaps of resources or even fail
(there are some limits on the list size I believe, postgres is 2000, not sure
about mysql). I think EXISTS is a better option.

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