I have just started to use FTS2 and it is working well but I would like
to ask any other users if they have had good or bad experiences and why
they would use FTS2 rather than FTS1. The software is new and I have
not seen any feedback at this stage and we are yet to apply large data
sets and high volumes of transactions.
We have developed some user functions to generate key strings and these
might be of interest to other users. Basically they concanentate the
columns of interest into a meta tag string then strip out noise words
such as prepositions and punctuation, upshift the words and then update
a column used for the FTS2 index. A complementary function similarly
processes a string to provide a compatible MATCH string. Soundex
versions of the words can be added.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------