0

I'm trying to use an SQLite database as a storage file for time series data. (The file will contain results of a simulation).

Some characteristics of the application:

  • It generates a lot of time series data in a short time (10000-100000 records per second).
  • There is a single writer and no readers.
  • Data is written to multiple tables (each table contains time series data).
  • If the application/system crashes most data (but not all) should be written to disk.
  • Total data is limited to MB/GB range.

How can I optimize SQLite for fastest insertion?

tyr.bentsen
  • 151
  • 1
  • 6
  • I think the real answer here is, "you can't". Even SQLite's site mentions that this isn't really a great type of use case for the product on their [Appropriate USes For SQLite](https://www.sqlite.org/whentouse.html) page. – esqew Jul 16 '21 at 14:47

0 Answers0