RE: [sqlite] In-memory DB performance tuning

Arthur, Full source and a small test app are at http://sourceforge.net/projects/adodotnetsqlite > -Original Message- > From: Arthur C. Hsu [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 18, 2003 2:22 AM > To: Tim McDaniel; [EMAIL PROTECTED] > Subject: RE: [sqlite] In-memory DB

[sqlite] Building with msvc6 ?

Hi I am having problems building SQLite with msvc6 (linux build went fine). So this is probably due to my total lack of experience with MS compilers. Compiling source code in sqlite_source compiles fine. I built this into a static lib with multithreading, dynamic linking and debug switched

Re: [sqlite] In-memory DB performance tuning

On Tue, 2003-11-18 at 00:55, Arthur C. Hsu wrote: > Hello, > > I have an in-memory DB and try to perform inserts to tables inside. Seems > that there are some performance bottlenecks for continuous inserts. The row > insertion speed will drop dramatically after the first 6000 rows are >

RE: [sqlite] In-memory DB performance tuning

Thanks for the quick response. Any samples that I can reference? -Arthur -Original Message- From: Tim McDaniel [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 11:54 PM To: [EMAIL PROTECTED] Subject: RE: [sqlite] In-memory DB performance tuning Arthur, I've just done some

[sqlite] database is locked

Hi all, I'm trying SQLite with Zope and it works fine, but when I use the browser's [Stop] button to interrupt the request it gives me the message: "database is locked" At this point it is not possible to continue the work unless I restart the Zope daemon. What can I do to avoid this

RE: [sqlite] In-memory DB performance tuning

Arthur, I've just done some performance tests using our ADO.NET provider for SQLite. On a 2GHz P4 system, we get about 35000 inserts/sec and 175000 reads/sec. This is with a file db using a transaction, or an in-memory db without transaction, they both perform the same. The performance is

RE: [sqlite] In-memory DB performance tuning

Yes I know the Berkeley DB or gdbm solutions out there. However, I need multicolumns and I need more sophiscated feature like ORDER BY and GROUP BY. -Arthur -Original Message- From: Steve Dekorte [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 10:38 PM To: Arthur C. Hsu Cc: