I'm planning to use SQLite in an application that has a lot of rows (1M+)
with a moderate number of columns (about 50) with the data being somewhat
sparsely populated - ie each row may only have data in a primary column and
5 other columns. Will I get a performance hit - in terms of the size of the
file - for all the unused columns? The other option would be to have a table
per column, but then I need an extra column (primary) per table to tie the
data together.
I want to store (about 50) pieces of information each of which may or may
not be logged at a reasonably high rate.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------