Hi there, I have to store and retrieve up to 2000 parameters. The parameters can have real and integer values. The max. change rate is 100ms and the max. duration is up to some hours.
The simple solution would be to use plain binary files. It's fast but not flexible. So I came to sqlite. Before starting I would like to ask if someone could give me some advice which way to go. Here are my current versions. Version 1: One big table with time stamp and one column for each parameter - I can have up to SQLITE_MAX_COLUMNS=2000 but how can I insert all values with only SQLITE_MAX_VARIABLE_NUMBER=999? - What about space consumption if NULL values are given? Version 2: One table for each parameter with time stamp and value - Does this scale for up to 2000 parameters? - Can sqlite handle so much tables? Version 3: One table with time stamp, parameter id and parameter value - Is it working when all values change? - Is retrieving values for one parameter fast? I will write and read the data on the same time. But writing should have priority. I could live with a potential lost of data because of a power failure. So I will use try the settings of the options "synchronous" and "journal_mode". Anything else I should consider? Thank you rene _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
