Re: Single Column vs Multiple Columns

2010-12-17 Thread Jonathan Ellis
The performance difference is negligible and the other drawbacks are significant, e.g., losing the ability to create indexes on a column. On Fri, Dec 17, 2010 at 11:49 AM, Ericson, Doug wrote: > I have a data model where each read and each write will read and write > all data for a given key. T

Single Column vs Multiple Columns

2010-12-17 Thread Ericson, Doug
I have a data model where each read and each write will read and write all data for a given key. Thus, does it make more sense to separate the data into multiple columns, or does it make more sense to store all data in a single column? My understanding is that breaking data into multiple colum