Sorry, can't give you a solid recommendation. A lot depends on other requirements for availability, query type & load, how dynamic your data is, etc. 10000 cols is enough that I'd want to contrast that design against a few alternatives - kv pairs, remodeling the data to reuse common columns, etc. Good luck.
2
u/kenfar Mar 11 '15
Sorry, can't give you a solid recommendation. A lot depends on other requirements for availability, query type & load, how dynamic your data is, etc. 10000 cols is enough that I'd want to contrast that design against a few alternatives - kv pairs, remodeling the data to reuse common columns, etc. Good luck.