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