Folks.
I have just started learning about Full Text search in SQlite, and I
have some questions
1) With the Amalgamated Sqlite, I guess to enable FTS I just #define
SQLITE_ENABLE_FTS2 at the start of sqlite3.c
Is there anything else I have to do to switch it on ?
2) If I want to do a full text (google style) search across 6 columns
in my database, what is the procedure? Currently I conjor up a
long SQL query with lots of ands and ors. What is to be gained
using FTS ?
3) It seems that FTS is basically a special table. Do I have to fill
this table in parallel with my regular columns ? (so its in sync) or
do I recreate the FTS table on every search ? Or do I just fill the
FTS table on its own, and stop using my regular tables altogether ?
thanks for any general insight for folks just starting to look at
Full Text Search
Cheers
--
[EMAIL PROTECTED]
Tel: +44 208 340 5677
fax: +44 870 055 7790
http://www.gallery.co.uk
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
