"A. Pagaltzis" <[EMAIL PROTECTED]> wrote: > > At the same time, to my knowledge, a query which has an `ORDER > BY` clause always has to produce all results before it can apply > a `LIMIT` to the result set, so at least in that case, what you > want should be possible. >
Depends. SQLite will use an index to satisfy the ORDER BY clause if it can, and in that case it is *not* necessary to produce all results before applying the LIMIT. -- D. Richard Hipp <[EMAIL PROTECTED]>