Thank you all for your input.
-Spiros
--
Image Video & Multimedia Systems Lab.
Department of Electrical & Computer Eng.
National Technical University of Athens
http://www.image.ece.ntua.gr
[EMAIL PROTECTED] wrote:
Spiros Ioannou <[EMAIL PROTECTED]> wrote:
John Stanton wrote:
Sqlite does cater for text searching. Look at FTS.
This is not text searching. No stemming, etc etc is required. Column has
exactly 1 word, and the 'LIKE' substring matching is performed at the
words' first characters (not end-characters).
Thanks,
Index the column and use GLOB with a trailing '*' instead
of LIKE with a trailing '%'. Make the search string a
single string literal token in the SQL:
SELECT * FROM table WHERE xyz GLOB 'abc*';
Do not use an expression for 'abc*'. Do not use bound
parameters for 'abc*'. Make it a literal string within
the SQL. If you do these things, then SQLite will use
an index to do the search and it will be very fast. Way
faster than fgrep.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
