I have an app currently that needs a list sorted alphabetically with alpha-numeric chars. I am using a query and then narrowing the results into an array and then creating two lists for an autosuggest. Imagine searching by an alphanumeric ID (not SQL ID) and also by the description:
1234ii -- apple 1234i -- banana 123x -- orange orange -- 123x banana -- 1234i apple -- 1234ii Then once the sorting is completed, I need to grab the unique ID (incremental SQL ID) from the original array again and then use that to update the database. Currently I am building the array, sorting with quickSort2D(), building the list and then to grab the SQL ID from the array again I use a function that loops through the array to match ID & ' -- ' & text or vice versa. This takes about 20 seconds to build. Also, this is something that will change per page refresh so storing anything in memory is pretty much nil. Any thoughts on simplifying the process? Anyone have experience with speeding up array processes? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
