casional write operation in the midst of these reads
> cause any permanent slow down to the read time? Thanks.
>
> Mike Borland
>
> -Original Message-
> From: Nuno Lucas [mailto:ntlu...@gmail.com]
> Sent: Friday, June 12, 2009 7:16 PM
> To: General Discussion of SQL
On 15 Jun 2009, at 10:11pm, Mike Borland wrote:
>
> When I start the 900 read iterations (always in the same order), the
> first one generally reads in about 50ms and by the last read, it's
> taking roughly 1000ms. Sometimes it slows down immediately,
> sometimes after the 100th iteration.
Also is there an index on the table B.ID field?
--- On Mon, 6/15/09, Mike Borland wrote:
> From: Mike Borland
> Subject: Re: [sqlite] sqlite3_step performance degredation
> To: "General Discussion of SQLite Database"
> Date: Monday, June 15, 2009, 4:11 PM
> Nuno, u
all of table A?
I think that would be faster overall and prevent any locking issues.
--- On Mon, 6/15/09, Mike Borland wrote:
> From: Mike Borland
> Subject: Re: [sqlite] sqlite3_step performance degredation
> To: "General Discussion of SQLite Database"
> Date: Monday,
ssage-
From: Nuno Lucas [mailto:ntlu...@gmail.com]
Sent: Friday, June 12, 2009 7:16 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] sqlite3_step performance degredation
On Sat, Jun 13, 2009 at 1:52 AM, Mike
Borland wrote:
> I have a fairly complex program where I a
On Sat, Jun 13, 2009 at 1:52 AM, Mike
Borland wrote:
> I have a fairly complex program where I am seeing a performance
> degradation of the sqlite3_step() function. Basically I'm iterating
> roughly 200 rows at a time, over and over. The only work happening
> during the iteration is I'm copying t
SQLite Database
Subject: Re: [sqlite] sqlite3_step performance degredation
On 13 Jun 2009, at 1:52am, Mike Borland wrote:
> I have a fairly complex program where I am seeing a performance
> degradation of the sqlite3_step() function. Basically I'm iterating
> roughly 200 rows at a t
On 13 Jun 2009, at 1:52am, Mike Borland wrote:
> I have a fairly complex program where I am seeing a performance
> degradation of the sqlite3_step() function. Basically I'm iterating
> roughly 200 rows at a time, over and over. The only work happening
> during the iteration is I'm copying the r
Hi all!
I have a fairly complex program where I am seeing a performance
degradation of the sqlite3_step() function. Basically I'm iterating
roughly 200 rows at a time, over and over. The only work happening
during the iteration is I'm copying the record into an array. At first,
sqlite3_step() t
9 matches
Mail list logo