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
