>>if you create a variable, you should make that variable local to the function/method if it's only going to be used within that function.
Oh I see, you're right, but I still don't see the utility to name the query, then to create a variable. >>Garbage collection doesn't happen immediately when there are no longer references to an object in Java. I was not referring to the CF or Java memory space, but to the ODBC or JDBC driver. If a query has a name, CF cannot close the connection until the whole page is processed, because the query can still be used. If a query has no name, there is no reason the connection cannot be closed right away. >>Finally, I'm pretty confident that even if garbage collection occurred, the unnamed query object would exist until the CF page in question has completed execution - otherwise, you wouldn't be able to reference CFQUERY.ExecutionTime at the bottom of your page. Of course, I don't now exactly how queries and debug information is handled by CF, all I can say is that if I had myself to print the execution time at the end of the page, I wouldn't need to keep the connection open until the end. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289942 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
