Version 3.6.14.1 solved the problem.
Thanks.
---Original Message---
From: Dan
Date: 14/05/2009 11:21:33
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Bad UPDATE performance
On May 14, 2009, at 2:33 PM, Ofir Neuman wrote:
> Dan,
>
> Before I got you
On May 14, 2009, at 2:33 PM, Ofir Neuman wrote:
> Dan,
>
> Before I got your reply I checked it with Pcache1RemoveFromHash()
> and it
> fixed the problem.
>
> I will re-check this issue with pCache->nPage-- but I guess that it
> will fix
> the problem as well.
>
> Thanks for the help.
>
> Wil
veFromHash().
>
> Dan.
>
>
>
> > Thanks,
> > Ofir.
> >
> >
> > ---Original Message---
> >
> > From: Dan
> > Date: 05/13/09 07:23:16
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] Bad U
---
>
> From: Dan
> Date: 05/13/09 07:23:16
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Bad UPDATE performance
>
> On May 13, 2009, at 3:15 AM, Ofir Neuman wrote:
>
>> Hi,
>>
>> Using version 3.6.10.0.
>>
>> I have a prob
, should I add only the following line as
suggested?
Pcache1RemoveFromHash(pPage);
Thanks,
Ofir.
---Original Message---
From: Dan
Date: 05/13/09 07:23:16
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Bad UPDATE performance
On May 13, 2009, at 3:15 AM, Ofir Ne
ssage---
From: Pavel Ivanov
Date: 05/13/09 04:28:06
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Bad UPDATE performance
Just a couple of questions that can clarify situation:
Do you work with pragma synchronous = FULL?
Does the behavior of the journal you have described remai
On May 13, 2009, at 3:15 AM, Ofir Neuman wrote:
> Hi,
>
> Using version 3.6.10.0.
>
> I have a problem that my application becomes slow after awhile with no
> specific reasonI got a chance to reproduce it on development
> environment and
> have noticed that UPDATE of 200 records within transact
Just a couple of questions that can clarify situation:
Do you work with pragma synchronous = FULL?
Does the behavior of the journal you have described remains if you
change pragma journal_mode = PERSIST?
Pavel
On Tue, May 12, 2009 at 4:15 PM, Ofir Neuman wrote:
> Hi,
>
> Using version 3.6.10.0.
Hi,
Using version 3.6.10.0.
I have a problem that my application becomes slow after awhile with no
specific reasonI got a chance to reproduce it on development environment and
have noticed that UPDATE of 200 records within transaction takes more than
20 sec.
When the application first run the
Hi,
Using version 3.6.10.0.
I have a problem that my application becomes slow after awhile with no
specific reasonI got a chance to reproduce it on development environment and
have noticed that UPDATE of 200 records within transaction takes more than
20 sec.
When the application first run the
10 matches
Mail list logo