This is not really related to Rails, but is a more generalized DB
question. An the answer is that it all depends.
Yes you should normalize the tables, and yes you have to go through join
tables to get the data you want. But that is what relational databases
are all about, that is their job. Relational databases have been around
a long time and all that kind of code has been optimized, so you should
get a fast response. I use Oracle a lot and I know that having the right
indexes set-up is the key to getting a query to work efficiently. I
guess it would be similar for other databases.
If you have lots of data, you maywant to start to de-normalize the data.
But in my mind that does not really extend to putting extra keys on join
A good example of de-normalisation is if you want say a count of how
many invoices were paid within x days. You have an invoice issued date
and an invoice paid date, so you need to calculate how many days between
the 2 dates everytime you want to do the query how many invoices paid
within x days.
If the query is infrequent or there are only a few invoices it is not a
problem. But when the query frequency goes up or the number of invoices
is huge then you denormalize the data by storing on the invoice how many
days to took to be paid.
Keeping a normalized database makes it easier to maintain and is clearer
to understand. Only compromize by denormalization where there is a clear
case of benifits.
I have a question on normalizing:
lets say i have three tables table1, table2 and table3
1 has many records in 2 and 2 has many records in 3.
If i normalize it right, i can get records in table3 only through a join
with table 2. i can imagine this is not the best solution for speed and
Could it be smart to include the primary key of table 1 also in table 3,
so that there is also a direct connection between the 2 or is this a
real bad praktice?
are there developers out there who choose to do so?
Would love to hear your opinions