[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