Oft times, what I will do in the case that I requirements to return large amounts of data is use a query that returns n records at a time instead of the entire recordset in order to preserve memory. Chris J <[EMAIL PROTECTED]> wrote: I was told by one of my instructors in an Allaire CF class that the JIT compiler scopes all object lifetimes based on when they are first needed to the last time they are used.
If that is correct, there is no need to delete a query as the server will allocate and deallocate any object as needed. Chris Jensen --- Christian Watt wrote: > Does anyone know if there is a way to delete query > results, before the page > is done processing??? > I have a couple of pages that compile info and send > mass emails, but some of > the queries are only needed for a short period, but > (correct me if I am > wrong) the results of those queries will stay in > memory until the page is > done. Well, when one of the results can easily have > over 50,000 rows, that > is a lot of memory that could be freed up and either > speed up the other > processes running, or allow more to be run > simultaniously. Any answer or > push in the right direction would be VERY much > appreciated. > > Thank You, > Christian Watt > SkillPath Seminars > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
