SQLite Forum

sqlite write performance is slower than the filesystem
Login
So to be complete I updated the code [rev3](https://gist.github.com/bioinfornatics/2870d9e7dba192114f32ce8299796269) in order to bench write rows into the database vs sequential write.

And added a second part which bench to select row if the first field is into a list.
I compare too with and without primary key (constraint).

```
text was writed in 0.10 seconds.
database was writed in 0.73 seconds.
database with constraint was writed in 1.24 seconds.
text selected in 0.31 seconds.
database selected in 0.00 seconds.
database with constraint selected in 0.00 seconds.
```