List, I am interested in some pointers on how I should build a search interface for a client. The product database that is to be searched will ultimately hold between 15,000 and 20,000 individual products. Each product may have multiple category references (accomplished by a link table), and the average number of category references per product is currently 5, although that may change. Its still too early to tell, but at this rate this means that I may have approximately 100,000 records in the link table. The client wants to be able to do a text search against the product name, and also wants to be able to filter the results by things such as manufacturer (stored with the product as BrandID) and category. I'm sure that other filters (price, inventory, etc) will be asked for soon. We're using SQL 6.5, so I don't have full text indexing at the database level, which means I'm probably going to use Verity. What would be the best way to accomplish this? Should I just build a Verity collection of product names, run the search against that, and then manually loop through and filter out records based upon the user's criteria. This seems rather inefficient since I may end up manually looping through a 15,000 record query to pull out 2 records. I know I could use the MAXROWS parameter to limit the results, but I'd like to know of other approaches. Thanks in advance for any ideas, Seth Petry-Johnson Argo Enterprise and Associates ------------------------------------------------------------------------------ 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.
