System.Data.SQLite

 I have a bunch of data that arrives a few times a second. Currently, I cache all the data into a map and after 5 minutes, dump it out to the database.  Having to maintain the map structure and and write it out every 5 minutes is more work than I want. Would it be possible to start a transaction, then do an insert for every  piece of data as it arrives, and then use a timer to do the commit every 5 minutes? Is this crazy? Any help is appreciated. Thanks, maxinuruguay

Certainly ... that's not an unreasonable thing to do, especially if your database is on the local harddrive.

At most, 5 minutes of data will be lost in the event of a catastrophic failure between commits.

Robert