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

Reply via email to