> other fields in the table. The question is, do I do this search using an
SP
> directly on the table or do I suck the whole data set into a verity
> collection and use this. Speed is obviously an issue.
if you also need to return the rest of the row then maybe sql server's full
text indexing might be more appropriate. it would have been nice to start
filling that table with it in place but whether you use it or verity you
will take
a hit to index this. add a TIMESTAMP column if this table's data will
change so you can do granular incremental indexing.
we've found sql server full text indexing to beat verity six ways to sunday
and its 2-3 times faster than WHERE clauses with LIKE and wildcards....
and its basically "free" if you already own sql server.
------------------------------------------------------------------------------
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.
