phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From F21 <f21.gro...@gmail.com>
Subject Re: What are some use-cases for JOINs?
Date Thu, 20 Oct 2016 23:54:00 GMT
P.S. I meant to say normalizing rather than de-normalizing.

On 21/10/2016 10:36 AM, F21 wrote:
> 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