Destroying objects and closing connections ensures resources are returned to the system. Objects and connections should be closed and destroyed in the opposite order in which they were created. Wait to create objects and open connections until immediately before they’re needed. Likewise, destroy objects and close connections immediately after you’re through with them.
- Example:
- Set objFso = Server.CreateObject(“Scripting.FileSystemObject”)
- set f = objFSO.OpenTextFile…
- f.Close
- set f = Nothing
- set objRS = Nothing
- set objConn = Nothing
- set objFso = Nothing
