I have a SQL table with just over 1/2 million records in it. I have a text
field in this table which holds a number of criteria for a record. I want
to perform a search based on the value of one of these criteria along with
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.
Andy
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
------------------------------------------------------------------
------------------------------------------------------------------------------
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.
