>> The follow-up to this is what is the purpose of full mutex mode and when >> should it be used over no mutex mode?
>The mutex is useful when SQLite can tell that your commands are >actually part of two separate efforts. i.e. when you’re using two >different connections. The mutex is used to prevent multiple concurrent entry (ie, calling an sqlite3_* function) using the same connection from multiple threads. (ie, serialization). It does not provide isolation of any sort. THat is to say that you can prepare a statement on a connection and then step it on another and finzalize on a third. What you cannot do (and what serialization prevents) is have two threads make calls at the same time on the same connection object. You would use no mutex mode if YOUR CODE ensures that there will never be an attempt at concurrent entry on a connection across threads. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. > > >Simon. >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
