On Mar 31, 2006 8:06 AM, Marco Bambini wrote: > > 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 > > The document refers to version 2.8.6 (10 September 2003), a lot of > changes occurs in sqlite since that version.
Yes, I know it's for an old version, but the part I was referring was ONLY to using the 'LIKE' with a index. Does SQLite currently uses an index (if present) when the search is made with 'LIKE' or performs a full table scan? > Anyway, sqlite doesn't officially supports full text index, > but a guy wrote a small full text search engine for sqlite3 on > sourceforge.net. > It is C/C++ code and I am not sure you can do the same things with > the REALSQLDatabase, even if I am quite sure you can recreate the > same algorithms with RB and SQLite3ProfessionalPlugin. <snip> > > http://sourceforge.net/projects/ft3 Their home page has also very good info: http://ft3.sourceforge.net/ It would be great if REALSQLDatabase had this implemented or if someone developed a plugin to use in conjunction with it. 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>
