ASP rs Turn off problem

After using Rs.close, you can open the data table directly with Rs.Open;
If you use Set rs = Nothing to clear the RS object from memory, loading the RS object again requires the use of Set Rs=server.createobject ("Adodb.recordset") to recreate the object;
If the RS object is not cleared from memory using Set rs = Nothing, the RS object is loaded again, and the set Rs=server.createobject ("Adodb.recordset") is used not only to slow down the system, but also to make an error.

ASP rs Turn off problem