[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