SQLite Forum

sqlite write performance is slower than the filesystem
Login
I repeat 3 times the writes process and compute the mean time.


I try to do a fair comparison with the classical way wich is:

1. open file
2. do the write
3. close file


I updated [the code](https://gist.github.com/bioinfornatics/2870d9e7dba192114f32ce8299796269) to remove time spent on SQLite database connection and Configuration as we coud consider that this operation is done only a few time during an application life

```
./write_perf_db_txt.py
database was writed in 0.5052063270122744 seconds.
text was writed in 0.10451052167142431 seconds.
```