> Which would be faster - a verity collection, or using SQL 7's Full-text
> indexing? We are probably talking about well over 20,000 individual
> records.
i didn't see any answers to this so...from our work sql server 7
full text indexing beats verity flat out if you have to come back
to the db for row details. besides the obvious hit of having to
re-query the db, verity doesn't cache queries, etc. its also a
shotgun search thru the "body" of your text data which may be
from several columns & thus hard or impossible to id. on top of
that verity doesn't work w/thai language ;-)
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
