Why I love ColdFusion

Because my first use of the ColdFusion AutoSuggest control took me 10 minutes to implement. I was doing a cfselect with a bind to load all cities in a state. Unfortunately, with more than 5,000 cities in some states the application was getting seriously bogged down with huge asynchronous http responses in the background.

Ten minutes later I have a solution in production and customers are happy.

LOAAutoSuggest.png

Posted by Daniel Short on Feb 5, 2009 at 2:42 PM | Categories: ColdFusion -

2 Comments

Jeff

Jeff wrote on 02/22/09 5:15 AM

Dan, what was your final solution? How did you overcome the large background hits?
Daniel Short

Daniel Short wrote on 02/23/09 8:12 AM

The final solution was just using the autosuggest and a TOP 10 on the SELECT. Instead of getting back 3,000 records that have to be serialized into JSON and then back into a huge