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. _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
