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
