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>
