Interesting problem.. perhaps create a separate table of search terms and results. When someone starts typing, after maybe 5 characters, search this table and if found, display those results. IF it is not in the search table, do a real search, but only retrieve the top 5 matches- order by popularity or if you don't track popularity, by date or whatever... and then also insert that search term and result into the search table.
If the site changes frequently, run an automated task every night to refresh those search terms. You can perhaps manually edit them also if you want certain words to be suggested in the future At 11:37 AM 5/20/2010, you wrote: >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
