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
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
: 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
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
-
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