Ryan Johnson <ryan.john...@cs.utoronto.ca> wrote: > Is each column associated with a different sensor? If so, do sensors > routinely generate data at the same time and combine their entries? Do > sensors emit data frequently? > > If any of the above is false, I'd definitely store each column in its > own table
Or else, everything in a single table, say, Readings(timestamp, sensorId, value). -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users