> I believe from the description that this is one single threaded application 
> per computer, for N computers, each using a single connection object pointing 
> to the same database file on a remote filesystem.

> Therefore, each database access is locking out all the others.  Multiple 
> connections will not make a difference.  THe transactions (which include 
> selects which will be exclusive) are not being finalized/commit'd 
> expeditiously enough.

> You would still need to expect and handle BUSY/LOCK conditions however as 
> there is certainty that two such clients will attempt to access the database 
> at the same instant. 

It is actually a multi-threaded application with each thread using the same 
connection object
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to