Re: [sqlite] Client/Server Environment

2004-11-10 Thread David Morel
Le mar 09/11/2004 à 17:52, Gerhard Haering a écrit : > On Tue, Nov 09, 2004 at 10:45:35AM -0500, Richard Boehme wrote: > > Hi there. How well does SQLite do in a client/server environment > > where the SQLite database is handling a batch of 100 inserts and the > > same number of queries a every 0.5

Re: [sqlite] Client/Server Environment

2004-11-09 Thread ben . carlyle
Hello, "Clay Dowling" <[EMAIL PROTECTED]> 09/11/2004 02:39 AM Please respond to sqlite-users To: [EMAIL PROTECTED] cc: Subject: Re: [sqlite] Client/Server Environment > Richard Boehme said: > > Hi there. How well does SQL

Re: [sqlite] Client/Server Environment

2004-11-09 Thread Clay Dowling
Richard Boehme said: > This is an extreme case -- records would usually be updated every minute > or so. Usually there might be 10 computers trading information (about > 100 records every few minutes), for example. I was extrpolating an > extreme test case where the system is very heavily used. >

Re: [sqlite] Client/Server Environment

2004-11-09 Thread Richard Boehme
This is an extreme case -- records would usually be updated every minute or so. Usually there might be 10 computers trading information (about 100 records every few minutes), for example. I was extrpolating an extreme test case where the system is very heavily used. In such a situation, we woul

Re: [sqlite] Client/Server Environment

2004-11-09 Thread Gerhard Haering
On Tue, Nov 09, 2004 at 10:45:35AM -0500, Richard Boehme wrote: > Hi there. How well does SQLite do in a client/server environment > where the SQLite database is handling a batch of 100 inserts and the > same number of queries a every 0.5 seconds? The inserts would be > batched into a transaction.

Re: [sqlite] Client/Server Environment

2004-11-09 Thread Clay Dowling
Richard Boehme said: > Hi there. How well does SQLite do in a client/server environment where > the SQLite database is handling a batch of 100 inserts and the same > number of queries a every 0.5 seconds? The inserts would be batched into > a transaction. The queries would most likely not. I'm no

[sqlite] Client/Server Environment

2004-11-09 Thread Richard Boehme
Hi there. How well does SQLite do in a client/server environment where the SQLite database is handling a batch of 100 inserts and the same number of queries a every 0.5 seconds? The inserts would be batched into a transaction. The queries would most likely not. Thanks for the help. Richard Boeh