Looking for any ideas here.
I'm running a cfloop over a query from a database with a little over 60,000 records in it on MSSQL. I am doing a cfflush so I can watch what record it is on so I can keep up with how quickly or slowly the loop is running. The problem is after about 4850ish records the loop slows waaay down. Any idea why the speed change or how I can stop it from happening? All I am doing is querying 2 columns and based on the data in those 2 I am updating 3 other columns. So it looks up the data then loops over it then updates each record with some new data. Runs great till about 95% of the loop. Looking for any ideas out there. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
