Adding to what Simon said, even the SQLite cache has to get filled initially as well. So those very first hits to the database are always the most expensive. Once commonly used pages (index pages?) are loaded, you're running closer to memory speed than disk speed.
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Monday, December 20, 2010 9:55 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] First(s) select are very slow On 20 Dec 2010, at 5:33pm, Vander Clock Stephane wrote: > so what the difference between the sqlite3 cache and the OS cache ? SQLite caches a number of database pages. Your operating system has its own caching. This depends on which OS you're using, and how it thinks it's addressing your data. For further details, do research on a site of the company that provides your OS. Your computer hardware, also, has many levels of caching: your hard disk drive probably has onboard caching; your motherboard has a cache; your processor chip also has caching. Simon. _______________________________________________ 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
