NYCPHP Meetup

NYPHP.org

[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