RE: [sqlite] In-memory DB performance tuning

2003-11-18 Thread Tim McDaniel
e] 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] >

Re: [sqlite] In-memory DB performance tuning

2003-11-18 Thread Mrs. Brisby
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

2003-11-18 Thread Arthur C. Hsu
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

RE: [sqlite] In-memory DB performance tuning

2003-11-18 Thread Tim McDaniel
nal Message- > From: Arthur C. Hsu [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 18, 2003 1:16 AM > To: 'Steve Dekorte' > Cc: [EMAIL PROTECTED] > Subject: RE: [sqlite] In-memory DB performance tuning > > > Yes I know the Berkeley DB or gdbm solutions out

RE: [sqlite] In-memory DB performance tuning

2003-11-18 Thread Arthur C. Hsu
: [EMAIL PROTECTED] Subject: Re: [sqlite] In-memory DB performance tuning On Nov 17, 2003, at 9:55 PM, Arthur C. Hsu wrote: > Any clues that I can further squeeze the performance? Or the > limitation is by design? I just can't realize why the first 6000 rows > are amazing fast