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 j
rievals. 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 re
etrieval 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 time
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
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 have'
ge-
From: 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 tak
Anish Enos Mathew wrote:
Hi Dennis,
I am stuck up with a problem. I want to calculate the
time taken for retrieval of 10,00,000 random records 10,00,000 times. I
am using a function getNumber for getting the random number and getTime
for getting the current time.getNumber function
Hi Dennis,
I am stuck up with a problem. I want to calculate the
time taken for retrieval of 10,00,000 random records 10,00,000 times. I
am using a function getNumber for getting the random number and getTime
for getting the current time.getNumber function will return a value
betwee
8 matches
Mail list logo