How about the various implementations to use SQLite in client server environment (based on wiki):
http://www.it77.de/sqlite/sqlite.htm http://www.oneledger.co.uk/sql4sockets.html http://users.iol.it/irwin/ http://sqlitedbms.sourceforge.net/ Does anyone have any experience any of these? Pros and cons? Thanks Uma [EMAIL PROTECTED] wrote: Huber Privat wrote: > Guten Tag > > Ich arbeite mit SQLite3 über ein Netzwerk. > > Wenn 2 User zur gleichen Zeit arbeiten wird der > Zugriff auf die SQLite3-Datenbank sehr langsam. > > Was mache ich falsch. > Bitte um Hilfe. > SQLite tends to not work well on a network filesystem. This is because network filesystems are themselves slow. This is especially true when you have multiple processes attempting to access the database at the same time. A lot of traffic has to go back and forth across the network in order to negotiate the approriate locks. If you have multiple clients access a single database over a network, you are probably better off using a client/server database engine. -- D. Richard Hipp ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
