Closing Record Sets

Results 1 to 2 of 2

Thread: Closing Record Sets

  1. #1
    Sshizoo Guest

    Default Closing Record Sets

    When a recordset is closed, does the information stay resident on the server? <BR><BR>I am using the below:<BR><BR>objRS.Close<BR>Set objRS = Nothing<BR><BR>If I do not set the recordset to nothing, will the information remain on the server&#039;s memory?

  2. #2
    RDM Guest

    Default Connection...

    The object stays in memory and takes up resources. The connection may also stay in tact. All ADO objects should be created, connected, used, disconnected, and then destroyed AS SOON AS POSSIBLE. Even if you are running multiple database access statements in the same page,<BR>repeat the process for each one. It may seem "stupid" to do this but IIS and it&#039;s connection pooling actually performs better. Test it, time it, then read up on it (especially if your server is Win2k). You&#039;ll be surprised...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts