On 1/13/2011 11:49 AM, Black, Michael (IS) wrote: > I have a shared library being called by a transaction-oriented Java > system. I'm doing periodic commits (every 5 seconds) to speed up > processing. However, I want to commit even when not polled by the > Java system. There could be long periods of silence and all the data > needs to be accessible by others. > > I thought of spawning a thread which would do the commits....but it > would appear that's not possible (or at least a really bad idea).
With reasonably modern SQLite versions, this shouldn't be a problem. SQLite API is thread-safe (there's just a single lock assigned to a connection that every API method acquires on entry and releases on exit). -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users