SQLite is not a client-server database. In the worst case,
when you query a database file over NFS, all the tables in
your query are sent over the network to be processed on
your cpu; so if you want to select one row from a table of
a million rows, the million rows are retrieved over the
network (in the worst case).
You may want to consider a client-server database for this
reason and also because there have been reports that
locking does not work reliably on some implementations of
NFS -- so you could be risking a corrupted db file if you
have multiple users.
I think this has been discussed on the list. You could
try a search of the archive:
<http://www.mail-archive.com/sqlite-users@sqlite.org/>
Regards
