Re: [sqlite] High retrieval time. Please help

2006-05-23 Thread Jay Sprenkle
On 5/23/06, Anish Enos Mathew <[EMAIL PROTECTED]> wrote: Hi Michael, I am retrieving records from the data base randomly. I want to perform 1,000,000 retrieval of 1,000,000 random records from the data base. When I am retrieving 15 bytes records from the data base, it works fine. It

RE: [sqlite] High retrieval time. Please help

2006-05-23 Thread Anish Enos Mathew
u suggest me a method by which the performance of > retrieval can be increased. > > -Original Message- > From: Michael Sizaki [mailto:[EMAIL PROTECTED] > > Sent: Saturday, May 20, 2006 12:00 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] High retrieval time. P

Re: [sqlite] High retrieval time. Please help

2006-05-22 Thread Michael Sizaki
val can be increased. -Original Message- From: Michael Sizaki [mailto:[EMAIL PROTECTED] Sent: Saturday, May 20, 2006 12:00 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] High retrieval time. Please help Anish, So my problem of retrieving 1,000,000 random records 1,000,000 times wor

RE: [sqlite] High retrieval time. Please help

2006-05-22 Thread Anish Enos Mathew
of 110 sec for 50,000 retrievals. Can u suggest me a method by which the performance of retrieval can be increased. -Original Message- From: Michael Sizaki [mailto:[EMAIL PROTECTED] Sent: Saturday, May 20, 2006 12:00 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] High retrieval time. P

Re: [sqlite] High retrieval time. Please help

2006-05-19 Thread Michael Sizaki
Anish, So my problem of retrieving 1,000,000 random records 1,000,000 times works fine for 15 bytes. But it is taking too long a time for 1k records. It is almost taking 102 seconds for retrieving 50,000 records of size 1k. Can u suggest me a way for reducing the time taken for the same? I

RE: [sqlite] High retrieval time. Please help

2006-05-19 Thread Anish Enos Mathew
om: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Thursday, May 18, 2006 9:00 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] High retrieval time. Please help Anish Enos Mathew wrote: > Hi Dennis, >I am stuck up with a problem. I want to calculate the > time taken for ret