Will SQLite work OK for a multi-user read-only application where the database resides on a Windows network drive?
A:
Most of the SQLite work is done in memory. If you have enough memory available SQLite won't do much I/O other than read the database once.
S.Lott
2008-12-31 18:18:15
That's per-process/connection though. If you're opening the application a lot or recycling new connections frequently that could cause issues with network transfer.
Joel Coehoorn
2008-12-31 18:41:09
Doubt that the SQLite transfers would compare with SQL/Server or Oracle connections.
S.Lott
2008-12-31 21:20:30
+1
A:
I think that, if you are only reading, then yes. According to SQLite FAQ writing might be a problem.
rkj
2008-12-31 18:20:11