I agree, saving one byte per row is fine and a better option than saving to a text file. You say a lot of overhead but it sounds like you have just as much overhead writing to a text file and then to the DB as well. How far back do you need to save data? Do you need data from 30 seconds ago?
|