Re: [sqlite] SQLite Performance

[Hugh Gibson]

>   SELECT * FROM tetragrams 
>   WHERE word1 = 'x' AND word2||'' = 'y' 
>   ORDER BY occs;

Better as

   SELECT * FROM tetragrams 
   WHERE word1 = 'x' AND +word2 = 'y' 
   ORDER BY occs;

See http://www.sqlite.org/optoverview.html section 6.

Hugh

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------