> No, the instance itself - the variable that corresponds to the > function itself - need not stay in memory. It will go out of scope > right after it runs, and will be eligible for garbage collection. But > the query that was created by that function will remain in memory > until all references to that query no longer exist.
But we're talking about a single request so if there is no garbage collection during a requests lifetime, being eligible or not makes no difference. Be that as it may, you're saying that the fact that a reference to the query is still in use, the query 'jumps' out of the UDF's local scope to live on in the requests memory. > thing to understand here is the difference between the stack and the > heap. References exist on the stack; the objects being referenced > exist in the heap. Can you expand a bit on what you're saying here? Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

