[lug] Which Database schema?
BC
bcarr at purgatoire.org
Tue Nov 13 08:32:46 MST 2018
I'm a hobbyist with no formal CS schooling background.
With respect to # of columns in a db table, is it better to have fewer
columns, each being much wider, or more columns with smaller chunks of
data in them? With more columns, the updates to the db would be to
fewer columns at each read/write.
I think I know the answer, but would appreciate your thoughts. I can
expand the question more if need be.
The db I'm using is SQLite but presumably the answer would apply to
all db types, right?
More information about the LUG
mailing list