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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636 --- Comment #11 from Srdjan Jankovic <srdjan@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.