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 Ofir Neuman
be released? I have to release my application soon and can't due to this bug (don't want to compile sqlite3.dll by myself rather to use the precompiled for windows) Thanks, Ofir. On Thu, May 14, 2009 at 7:53 AM, Dan wrote: > > On May 14, 2009, at 4:08 AM, Ofir Neuman wrote: > &

Re: [sqlite] Bad UPDATE performance

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

Re: [sqlite] Bad UPDATE performance

2009-05-13 Thread Ofir Neuman
ns 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. > > I have a problem that my application becomes slow after awhile with no > specific reasonI got a chance to reproduce it on development

[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

[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

[sqlite] Temporary table performance

2008-12-15 Thread Ofir Neuman
Hi All, I have a some performance problem on INSERT to temporary table. My temporary table is very simple: TABLE { ID TEXT (Primary key) // The format is GUID } On user request, I receive list of ids from outside component and would like to store them in a temporary table for later u

[sqlite] Fetch all result set to memory

2007-12-21 Thread Ofir Neuman
Hi, I'm using SQLite in a multithread application and I would like to fetch every select statement into the memory. I can't use sqlite3_get_table since it doesn't support Unicode as far as I know. Is there a better way to fetch all the result to memory other than fetching it one by one and bui

Re: [sqlite] ORDER BY Performance on 30,000 records

2007-12-04 Thread Ofir Neuman
Thanks, now it takes only few ms : ) - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Sunday, December 02, 2007 7:52 PM Subject: Re: [sqlite] ORDER BY Performance on 30,000 records On Dec 2, 2007, at 12:01 PM, Ofir Neuman wrote: Hi A

[sqlite] ORDER BY Performance on 30,000 records

2007-12-02 Thread Ofir Neuman
something like 30 ms. Tried to index also 'ModifiedDate' but it didn't help. What am i doing wrong? Thanks, Ofir Neuman.