> then its time for me to check it out..
its actually one of the few "big iron" things mySQL had had for sometime.
in sql server full text indexing (FTI) is better than verity because:
- yes it handles unicode, while i think the version of verity shipped with
mx doesn't yet
- you can do the text search & join on another table in one query (verity
will require another query)
- its run on the sql box (verity executes on the cf box)
- verity searches are flat flat flat, FTI takes advantage of sql server
native caching
- seems easier to maintain data (though you need to add a timestamp column
to your indexed table) than verity if your database is not static.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
