Classic ASP Discussion - Recordset andk Memory ’management’

Print Page | Close Window

Recordset andk Memory ’management’

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=8813
Printed Date: 01 April 2026 at 2:32am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Recordset andk Memory ’management’

Posted By: Gary
Subject: Recordset andk Memory ’management’
Date Posted: 12 January 2004 at 11:46am

When you create a recordset, the required memory to contain the rs is taken on the server - simple enough !!!

If you do not close/destroy the recordset within asp page, does the memory get released, and if som, when???

I thought that the memory would be freed up when the session ends - but this thought is now being challenged.

Pls somebody put me right.

Replies:

Posted By: MorningZ
Date Posted: 12 January 2004 at 1:33pm

its supposed to be destroyed automatically, but thats not always the case

just make it a programming habit to explicitly close and destroy objects to the database... its so little code it shouldn't even remotely be a problem to get used to

-------------
Contribute to the working anarchy we fondly call the Internet