I'm not sure if this will meet your specific needs, but... I have found this function from CFLIB helpful:
http://www.cflib.org/udf.cfm?ID=758 QueryDeDupe(theQuery, keyColumn) I would be very interested to see what the timing differences are!!! Please post to the list or let me know directly. Thanks, Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 -----Original Message----- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Thursday, December 30, 2004 3:05 PM To: CF-Talk Subject: QofQ: SELECT DISTINCT Hi All. I have some code that does a SELECT DISTINCT on a QofQ and it is really slow. For example, I have a dataset with about 150 records and the SELECT DISINCT is taking anything from 2 - 5 seconds to excute. Any ideas why and how to improve it? Andrew. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189028 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
