However this is not the end of the story because you now have to post process all your data to get it in a useable form. You also have potential issues with large indexes from TEXT fields used to store the CSV (Postgre in particular has issues), your tables are locked whilst maintaining these larger indexes, and you also have to use more storage for the TEXT field when you could have used an INT. There are more factors involved here.
Originally Posted by svidgen
That's certainly one of the other costs, though there are more.
is the inability to efficiently search, update, or remove single colors globally across all product rows.
The first rule of Tautology Club is the first rule of Tautology Club.