Hi Ryan. That custom tag is no help as I need to DISTINCT on three columns. As a work around for the moment, I'm creating a table in the mySQL datasource and then populating it, doing the select and then deleting the table and it is about 100 times (really) quicker. The QofQ takes about 2 seconds and the work around takes about 0.02 seconds, which just seems silly as it is doing so much more work.
Andrew. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189050 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
