I thought of this but not a lot of experience here since in my loop there are lots of ifs and conditions then updates etc. I'm reading up on it though.
-----Original Message----- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Wednesday, March 09, 2011 9:07 PM To: cf-talk Subject: RE: Performance Issue with CFLOOP Not sure what query you are calculating to add back to the original query, but can it not be done on the database via sql? It would be a hundreds times quicker than looping over a query to then do it. Regards, Andrew Scott http://www.andyscott.id.au/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm