This is probably 'cold start' vs 'warm start'. Ie, the database file is read from disk the first time, and cached in memory. On the second launch, some of the file is already in the OS's disk cache, so the I/O is much faster.
> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Derek Developer > Sent: Saturday, July 11, 2009 4:27 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] 50sec Delay on first launch > > When I launch my app the SQLite database and reads a portion of the > contents (about 30MB of a 100MB database). > On first launch it can take 50secs to load, yet subsequent loads are as > fast as 10sec. What is happening under the hood? > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
