Maybe version 5.0 with it's partial rendering will provide some of this
functionality.
Rick
-----Original Message-----
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 12:23 AM
To: CF-Talk
Subject: Re: Getting Rid of a Query
Rick,
Thanks. I'm pretty sure as well that the query doesn't persist between
requests, but maybe I didn't state this clearly enough.
If I've got a template that does a huge amount of processing, with many
queries and other memory-intensive operations, I'd just as soon release
memory ASAP _during_ the processing of the template. Once again, I'm not
sure how to do this, or even if CF's memory management and deallocation
mechanisms go into play before a template is fully processed. It would be
good to know, however.
Jim
----- Original Message -----
From: "Rick Lamb" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 6:09 PM
Subject: RE: Getting Rid of a Query
> I'm pretty sure that the only time the query is resident in memory is
during
> the initial request, unless you specify it to be cached or set to a
session
> variable. So I don't think that is going to get you anywhere. Although, it
> might be a good idea to look into a way to make sure the odbc connection
> doesn't persist beyond the initial database call. I'm not sure the best
way
> to do this. I know you can specify in CF admin not to maintain database
> connections. You may also look into using
> CFUSION_DISABLE_CONNECTIONS([DSN],1) to kill the connection.
>
> Rick
>
> -----Original Message-----
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 6:20 PM
> To: CF-Talk
> Subject: Getting Rid of a Query
>
>
> I need to run a query to create a list via ValueList(). Afterwards I no
> longer need the qeury itself. How can I get rid of it (deallocate the
> memory used) and does this actuall free the memory immediately? If it
> doesn't, I suppose there's no real point.
>
> Jim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
