Re: What are some use-cases for JOINs?

2016-10-20 Thread F21
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

What are some use-cases for JOINs?

2016-10-20 Thread F21
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