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

[sqlite] In-memory DB performance tuning

2003-11-17 Thread Arthur C. Hsu
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. That is Time ElapsedRows inserted Ro