In the real world you only need one user to start a transaction, and go to lunch, then the performance gets, as we say in the south, "mighty poor!'
Fred -----Original Message----- From: Balthasar Indermuehle [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 10:34 AM To: 'Williams, Ken'; [EMAIL PROTECTED] Subject: RE: [sqlite] Multiuser experience under win32 anyone? Thanks, I have read that from the FAQ, but how well/not well does it perform effectively (numbers)? Has anyone run tests on how many selects and inserts a second can be performned from, say, 5 clients that access the same DB located on a network drive? Balthasar Indermuehle Inside Systems GmbH http://www.inside.net "Louis Pasteur's theory of germs is ridiculous fiction." Pierre Pachet, Professor of Physiology at Toulouse, 1872 . -----Original Message----- From: Williams, Ken [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 09:19 To: 'Balthasar Indermuehle'; [EMAIL PROTECTED] Subject: RE: [sqlite] Multiuser experience under win32 anyone? > -----Original Message----- > From: Balthasar Indermuehle [mailto:[EMAIL PROTECTED] > Sent: Monday, March 15, 2004 10:03 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] Multiuser experience under win32 anyone? > > > Hi all, > > Has anyone been doing some testing on how sqlite performs in > a networked multiuser environment? If you mean that multiple users will try to connect to the DB at the same time, I'd say SQLite isn't going to perform well. Traditional client-server databases put a lot of work into supporting this model efficiently (by supporting things like table-level or row-level locking, rather than database-level like SQLite) and SQLite puts no work into it. This assumes that multiple users will be reading *and* writing. If they're all just reading, SQLite might be fine. -Ken --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
