Updating Records

[khurram]

I am trying to update about 15,000 records in a SQL database. The app is in CF and everytime I run it, the browser timesout. Also, I don't even know how far the update has run.

The code basically runs like this:

<CFOUTPUT query=&quot;x&quot;> <!-- About 15,000 records -->
<CFLOOP index=&quot;y&quot; from=&quot;1&quot; to=&quot;100&quot; step=&quot;1&quot;>
...
</CFLOOP>
</CFOUTPUT>

Can I have an update display across the screen that says something like this:

10 Records Updated ..
20 Records Updated ..
etc ..

I am assuming this will prevent the browser timeout as well as give me an update as to the progress. Thanks.

 

[RichardBro]

Try changing the <cfoutput query...> to a <cfloop query...> its about 7 times faster than cfoutput, so the page processing will take a lot less time

Richard