It works best to have a connection per thread.
On Tue, May 13, 2014 at 6:12 AM, d b <va230...@gmail.com> wrote: > Hi all, > > > My application is multithreaded. It maintains only connection per > application. Database accessed by single process only. ThreadA will do > database write operations(bulk) in a transaction. ThreadB will do single > write operation without transaction but same connection pointer. > > Here, application needs to synchronize the calls among threads by using > synchronization technique(critical_section/mutex)? (OR) begin transaction > and commit will synchronize the calls between threads? > > Please suggest. > > Thanks, > av. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users