Re: [sqlite] Bad UPDATE performance

2009-05-23 Thread Ofir Neuman
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

Re: [sqlite] Bad UPDATE performance

2009-05-14 Thread Dan
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. > >

Re: [sqlite] Bad UPDATE performance

2009-05-14 Thread Ofir Neuman
he1RemoveFromHash(). > > Dan. > > > > > Thanks, > > Ofir. > > > > > > ---Original Message--- > > > > From: Dan > > Date: 05/13/09 07:23:16 > > To: General Discussion of SQLite Database > > Subject: Re: [sqlite] B

Re: [sqlite] Bad UPDATE performance

2009-05-13 Thread Dan
t; > 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 problem th

Re: [sqlite] Bad UPDATE performance

2009-05-13 Thread Ofir Neuman
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 Neuman wrote

Re: [sqlite] Bad UPDATE performance

2009-05-13 Thread Ofir Neuman
--- 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 remains

Re: [sqlite] Bad UPDATE performance

2009-05-12 Thread Dan
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

Re: [sqlite] Bad UPDATE performance

2009-05-12 Thread Pavel Ivanov
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, > >

[sqlite] Bad UPDATE performance

2009-05-12 Thread Ofir Neuman
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

[sqlite] Bad UPDATE performance

2009-05-12 Thread Ofir Neuman
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