https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19532
Chris Cormack <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #31 from Chris Cormack <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
