Re: [sqlite] speed of ORDER BY clause?

[drh]

[EMAIL PROTECTED] wrote:
> 
>  SELECT <fields> FROM <table> WHERE recID IN (<record IDs>) ORDER BY dateFld
> 

Might go a lot faster if you put a "+" in fron of
recID.  Like this:

   SELECT * FROM table WHERE +recID IN (...) ORDER BY dateFld

Whether or not this is faster depends on what fraction of
redIDs actually match the (...). 
--
D. Richard Hipp   <[EMAIL PROTECTED]>