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. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
