[nycphp-talk] The user table
Rob Marscher
rmarscher at beaffinitive.com
Sun Mar 6 08:33:41 EST 2011
On Mar 5, 2011, at 4:54 PM, David Krings wrote:
> Stick everything into one table and if it makes sense duplicate partial data in a different table to minimize joins. Not only are the queries much simpler then and get executed faster, figuring out what goes on is also much easier. As a side effect you can find data inaccuracies easier and fix them as well. The downside is drive space usage, which will go up. But the times where a 120MB hard drive cost 800$ are long gone - and so is the prime reason for normalization.
This pretty much sums up why "nosql" databases have become so popular lately.
More information about the talk
mailing list
Automatic Email Organization without missing anything!