https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20447 --- Comment #103 from Joonas Kylmälä <joonas.kylmala@helsinki.fi> --- (In reply to Ere Maijala from comment #100)
(In reply to Joonas Kylmälä from comment #97)
Why is there deleted_on on in both holdings and holdings_metadata tables? Why is it not enough to have it just in holdings?
Because that's how it's done also for biblios in bug 20271. There's at least one practical upside: it allows one to fetch a metadata record without joining with the base table.
#1 rule in my database course was always use the normal form for databases. It feels wrong to have the data in one place: twice the possibility of having bugs and also taking twice as much space. I read quickly https://stackoverflow.com/questions/2623852/why-are-joins-bad-when-consideri... and in the end the performance difference might not be that big. I would like you to provide performance benchmarks if we are going to use the non-normalized way. -- You are receiving this mail because: You are watching all bug changes.