Message info
 
To:General Discussion of SQLite Database From:Simon Slavin Subject:Re: [sqlite] Using "attach database" to work around DB locking Date:Thu, 12 Apr 2012 16:44:16 +0100
 


On 12 Apr 2012, at 3:30pm, Gabriel Corneanu <gabrielcorneanu@gmail.com> wrote:

> Using WAL mode and lots of optimizations I am able to write >150000 records/s (one table with ~20 fields) and at the same time reading(processing) >300000 records/s.
>
> There are lots of tricks/variables (number of fields, page size, cache size, wal checkpoint size...) to achieve this.

Or you can do your immediate writing to a database in memory, and have another process dump memory to disk in the background. Depending on how recent you need reading you can read the one in memory or the one on disk.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users