Saving resources by closing conn/recordsets and using 'adModeRead'
Posted on 2003-11-04
Fairly simple asp question for the asp experts.( ihope)
I would like to code my pages to save as much resources as possible. Im using Access and ASP. So I need to save as much as possible.
I need to know how to use the adModeRead
in this connection.:
<!--#include file="../Connections/myconnection.asp" -->
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_myconnection_STRING
Recordset1.Source = "SELECT * FROM calendar"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1_numRows = 0
Also does this code close the connection AND the recordset, or is there other code that I should place at the bottom of the page?
set recordset1 = nothing
I use this on every asp page. I hope that this opens and closes connections to free up as much resource as possible, with out have to completely re-code many pages.
Thank you in advance.