Lee, You didn't mention the database. I know Microsoft SQL Server has a nifty text search capability built in. We had someone do a meeting on it for us one time and its lightening fast and less overhead to get setup than Verity. I am pretty sure that you can use Verity as well to search a database in case that isn't an option.
If speed is still a problem, launch without it and find out your most popular searches. Then build a small table for just the 500 most popular searches that will popup quickly and most users will be satisfied. Rick On Wed, May 19, 2010 at 8:12 PM, Les Mizzell <[email protected]> wrote: > > Working on a search for a site that's 100% database driven. Not sure I'm > going to be able to use Verity on it, so looking at other methods. > > I believe I have a view worked out in the database that I can query and > generate the proper URLs to get where needed. But, the client has now > thrown in a slight monkey wrench - he wants the search form to "suggest" > stuff when you start typing. > > Using cfinput auto-suggest isn't too much trouble, but there's going to > be a *TON* of data being searched and I'm not sure how to handle that. > You simply can't return every piece of text, minus common words, from > the database as a list of any type to "suggest". Or can you? > > How are others handling this sort of thing? > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 5130 (20100519) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
