Re: [sqlite] Sqlite aggregate cold/hot boot performance

2013-01-23 Thread Simon Slavin
On 23 Jan 2013, at 9:01am, Pierre Chatelier wrote: > [what I do not understand] > I perform a computer cold boot, launch my app, opens a doc, perform the > query. The sqlite3_step() takes some time (a few seconds).It's ok, the > query is rather complex. > Now, I close my

Re: [sqlite] Sqlite aggregate cold/hot boot performance

2013-01-23 Thread Pierre Chatelier
Hi, Is there some global cache retained by sqlite3.dll that makes my query faster ? Could it be rather related to some hard disk cache ? SQLite uses normal file accesses, so the operating system will try to cache the data. OK And how many GB is the system using for file caching? :) I

Re: [sqlite] Sqlite aggregate cold/hot boot performance

2013-01-23 Thread Clemens Ladisch
Pierre Chatelier wrote: > Is there some global cache retained by sqlite3.dll that makes my query > faster ? Could it be rather related to some hard disk cache ? SQLite uses normal file accesses, so the operating system will try to cache the data. > (please note that my database files where the

[sqlite] Sqlite aggregate cold/hot boot performance

2013-01-23 Thread Pierre Chatelier
Hello, I can observe a behaviour that I do not understand. [context] I have an application that links whith sqlite3.dll. I can open a document, and perform a query on it. That query is using an aggregate function, that I have created myself using the callbacks like sqlite_aggr_indexset_step...