hilaner wrote:
And - if I have to have sorted results as a small (but ordered!) part of big
amount of data - there is no way to make it faster...
SQLite will pull records out of the database in sorted order,
if you have an index on the columns of the ORDER BY clause and
you don't need to use a different index to satisfy the WHERE
clause. But in your case this won't help because you have DESC
on one term of the ORDER BY clause and ASC on the other. SQLite
could handle it if both terms where ASC or both where DESC, but
because they are different, it defeats the optimizer and SQLite
has to fall back to using an O(NlogN) sort after the fact.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565