Re: [sqlite] Multiuser experience under win32 anyone?

2004-03-15 Thread Jay Macaulay
> Hi all, > > Has anyone been doing some testing on how sqlite performs in a networked > multiuser environment? > > Cheers I think what I and a lot of other users do in a situation like this is to wrap a server around SQLite itself that serializes requests so that you only ever run the DB from one

RE: [sqlite] Multiuser experience under win32 anyone?

2004-03-15 Thread Fred Williams
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'; [EMA

Re: [sqlite] Multiuser experience under win32 anyone?

2004-03-15 Thread D. Richard Hipp
Balthasar Indermuehle wrote: Has anyone been doing some testing on how sqlite performs in a networked multiuser environment? Most network filesystems are *really slow*. This, in turn, makes SQLite run really slow when used over a network filesystem. You should look into a client/server model if yo

[sqlite] Magically turning a memory blob into an SQLite memory db?

2004-03-15 Thread Ng Pheng Siong
Hi, How difficult is it to have a blob in memory which contains a binary image of an SQLite disk database, from which to create an instance of an SQLite memory database? IOW, instead of creating an empty memory database and then populating it with data, I want to go from a blob of memory to an ap

RE: [sqlite] Multiuser experience under win32 anyone?

2004-03-15 Thread Balthasar Indermuehle
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 htt

RE: [sqlite] Multiuser experience under win32 anyone?

2004-03-15 Thread Williams, Ken
> -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

[sqlite] Multiuser experience under win32 anyone?

2004-03-15 Thread Balthasar Indermuehle
Hi all, Has anyone been doing some testing on how sqlite performs in a networked multiuser environment? Cheers 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 .

Re: [sqlite] Borland C++ Builder 6

2004-03-15 Thread D. Richard Hipp
eno wrote: Drew, Stephen wrote: Further to my original question, does anyone know why the SQLite library compiles when (and only when, as far as I can tell) the following lines in SQLiteInt.h : #include #include #include #include are replaced with the original C equivalents: #include #incl

Re: [sqlite] Borland C++ Builder 6

2004-03-15 Thread eno
Drew, Stephen wrote: Further to my original question, does anyone know why the SQLite library compiles when (and only when, as far as I can tell) the following lines in SQLiteInt.h : #include #include #include #include are replaced with the original C equivalents: #include #include #include

RE: [sqlite] Borland C++ Builder 6

2004-03-15 Thread Drew, Stephen
Further to my original question, does anyone know why the SQLite library compiles when (and only when, as far as I can tell) the following lines in SQLiteInt.h : #include #include #include #include are replaced with the original C equivalents: #include #include #include #include Thanks,

[sqlite] Borland C++ Builder 6

2004-03-15 Thread Drew, Stephen
Has anyone any experience of compiling the SQLite library with Borland C++ Builder 6 and it's shipped version of STLPort? Regards, Steve