jeudi 16 juillet 2015

Rapid inserts using SQLite

I'm developing a data logging application that will be writing a row to a SQLite database roughly every 100ms. Without using transactions, inserting 100 rows at this interval takes 20 seconds - twice as long as it should.

Does SQLite provide anything that can help with what I'm trying to do, or is it a case of rolling my own solution (e.g. committing a transaction every N rows or N seconds)?

Aucun commentaire:

Enregistrer un commentaire