On Mar 30, 2006 7:12 PM, Norman Palardy wrote:
>
> On Mar 30, 2006, at 10:07 AM, Alexander Bauza wrote:
>
> > OK, I think there is not!
>
> Put an index on a TEXT column and it will make some
> difference but it's
> not the same as a full text index that you can get in other
> databases.
Unfortunately that does not make any difference if the search is made
using 'LIKE' because SQLite will ignore the index and will perform a
full table scan. See 5.5.1 at:
http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html
Carlos
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|