https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19532 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chris@bigballofwax.co.nz --- Comment #31 from Chris Cormack <chris@bigballofwax.co.nz> --- (In reply to Jonathan Druart from comment #30)
(In reply to Petter Goksøyr Åsen from comment #29)
Quick comment: Given the troubles we have with duplicate primary keys in old/deleted tables, would't it be better to drop the old_recalls table, and keep it in one table, with a flag denoting if the recall is deleted or not?
Yes, see comment 5 as well. Aleisha, did you consider this alternative?
We did, but the reason old_issues exists, is because keeping it one massive table becomes really slow quite fast. With recalls this probably will take longer to be a problem, but having circulation stuff slowed down (specifically returns) by having millions of rows to check through was the reason the issues table was split in the first place. I don't believe one table that grows forever for circulation is a viable fix. -- You are receiving this mail because: You are watching all bug changes.