phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From F21 <f21.gro...@gmail.com>
Subject What are some use-cases for JOINs?
Date Thu, 20 Oct 2016 23:36:04 GMT
Hey all,

Normally, rather than de-normalizing my data, I prefer to have the data 
duplicated in 2 tables. With transactions, it is quite simple to ensure 
atomic updates to those 2 tables (especially for read-heavy apps). This 
also makes things easier to query and avoids the memory limits of hash 
joins.

Having said that, what are some use-cases of when JOINs should be used?

Cheers,

Francis


Mime
View raw message