On 12 Apr 2012, at 3:30pm, Gabriel Corneanu <gabrielcorne...@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
