RE: Query proactive termination, is this necessary?

2005-01-21 Thread Ian Skinner
Assuming you have a pretty standard loop something like this. cfloop ... cfquery name=foobar ... /cfquery /cfloop CF is not going to hang on to old versions of the query. Each time through the loop, it is going to replace the old query with a new one unless you are doing

RE: Query proactive termination, is this necessary?

2005-01-21 Thread Dave Watts
What is the most graceful way to terminate a CFQuery once you have used the results, and free up resources? I use a query within a loop. Would it be more efficient to terminate the query at the end of each cycle (assuming there is a graceful way) and let CF reestablish the query or leave