On Mar 30, 2006, at 10:33 PM, Carlos M wrote:
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
If you need to do "LIKE" searches it will not be helpful.
A number of databases do not have a useful full text index and you need
to do something else.
Lucene is one option that is available in some databases.
_______________________________________________
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>
|