so what the difference between the sqlite3 cache and the OS cache ?
On 12/20/2010 9:49 PM, Doug wrote: > Possibly because the OS file cache doesn't have any of your database file > loaded into memory yet (cold start), so those first selects are experiencing > I/O hits. After a number of them have been done, some/much of the file might > be in OS file cache memory, and selects are then hitting memory instead of > the much slower disk. > > Doug > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Vander Clock Stephane > Sent: Monday, December 20, 2010 8:43 AM > To: General Discussion of SQLite Database > Subject: [sqlite] First(s) select are very slow > > hello, > > why, on a big table (+5 000 000 rows with RTREE ndex) at the beginning, the > select is very slow to return (2-5 secondes), but after 1000 selects, it's > start to return immediatly (10 ms) ?? > > thanks by advance > st phane > _______________________________________________ > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users