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 > inserted

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

RE: [sqlite] In-memory DB performance tuning

2003-11-18 Thread Tim McDaniel
-Original 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 o

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

Re: [sqlite] In-memory DB performance tuning

2003-11-17 Thread Steve Dekorte
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 but later the speed drops down so dramatically. Hi Arthur, If you really need performance and ca