On May 20, 2008, at 4:15 PM, Serena Lien wrote:
> Thanks for your response. I do realize the performance of sqlite
> over the
> network will be slower than accessing local databases - I will
> restate if I
> wasn't clear - the question I asked is why sqlite accessing a
> networked
> database is slower WHEN that particular database is attached in a
> different
> database connection/process.
That is probably a question that cannot be answered without knowing
specifics of your network filesystem. Certainly we have NOT put code
in SQLite that says:
if( serena_is_accessing_multiple_times_on_network_filesystem()==TRUE ){
sqlite3_usleep(6000000);
}
I really do not know why it goes slowly on a network filesystem when
two or more clients are connected. I would guess it has something to
do with the locking and caching protocols of your network filesystem.
But that is only a guess. You talk as if this behavior is true of
every network filesystem. Is that true? Have you tried on a
different network filesystem? If you really need to know why it is
slow, open the code, attach a protocol analyzer to your network, and
figure it out. Let us know if you find anything interesting.
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
