View Single Post
Old 11-13-2015, 08:31 AM   #16
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 85,556
Karma: 93383099
Join Date: Nov 2006
Location: UK
Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6
Quote:
Originally Posted by eschwartz View Post
"Nontrivial".

The issue has come up before.
Replacing a "many to 1" relationship between series and books with a "many to many" relationship is not, in itself, a difficult problem; it can be done by adding a "book/series" link table into the database. But it would involve rewriting all the queries involving books and series, and every additional "join" in a query slows it down, so if (as I believe would be the case) the number of books that are in multiple series is small, the benefit of doing this is probably questionable.
HarryT is offline   Reply With Quote