[Koha-bugs] [Bug 20447] Add support for MARC holdings records
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Mar 5 15:14:01 CET 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20447
--- Comment #103 from Joonas Kylmälä <joonas.kylmala at 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-considering-scalability
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.
More information about the Koha-bugs
mailing list