On 22 May 2014, at 1:12pm, Hadashi, Rinat <rinat.hada...@intel.com> wrote:

> The first time I access a database takes significantly more time than 
> subsequent accesses.
> I am looking for ideas to shorten the time required for the first access.

Access it before you need it.

You understand that the first access needs to do more than later accesses, 
right ?  I
Depending on what more you're in it has to open the database file, read the 
schema, create a journal file, etc..  That's what's taking the time.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to