Hi, (SQLite v3.6.17, on ARM with Linux 2.6.18)

I'm currently investigating the applicability of SQLite in an embedded
application. Part of this would be to store configuration data, for
which SQLite seems like a natural fit.

I also have a requirement for exchange of realtime data between
processes. The data is only stored in RAM (probably on a tmpfs
filesystem in Linux, so it can be shared) and, while atomic commits are
valuable, it is not important to be robust in the face of reboots.

Testing shows that I can commit writes at about 400 transactions per
second and read tables at about 1400 queries per second. I have tried
changing PRAGMA settings for journal_mode to OFF, synchronous OFF and
temp_store to 2. These seem to have a small impact (to about 410
commits/second).

PRAGMA journal_mode; gives no output though which makes me suspicious as
to whether it is doing anything.

The performance so far is perhaps adequate, but since it takes up almost
100% CPU to do it, it will of course tail off when I start to do
anything with the data.

Are there any other configuration options (per DB) that I should be
considering, or other tips that might be relevant?

Thanks,
Nick.


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

Reply via email to