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
