I'm using 3.2.1 and have no index.
Note that i'm not talking about the query itself but the data retrieval.
----- Original Message -----
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, August 25, 2005 2:59 PM
Subject: Re: [sqlite] Duration of reading records seems longer when sortedas
not.
On Thu, 2005-08-25 at 05:56 -0700, Cory Nelson wrote:
I believe the recent release can use an index for sorting, so you may
want to try that.
To clarify: SQLite has been able to use indices for sorting
for a long time - going back to version 2.5.1 on 2002-June-19.
Recent releases just do a better job of it.
--
D. Richard Hipp <[EMAIL PROTECTED]>
