improving performance

[Joey Martin]

If I call the database 5 times on a page using multiple queries, recordsets,
etc what all do I need to do to "close it all out"?

I close the database connection at the end of each page. Should I clear out
the recordsets or anything else? I just want to make sure I am performing
good practices.

Thanks.

 

[John Blessing]

If I call the database 5 times on a page using multiple queries, recordsets,
etc what all do I need to do to "close it all out"?

I close the database connection at the end of each page. Should I clear out
the recordsets or anything else? I just want to make sure I am performing
good practices.

Thanks.

Close each recordset, close each connection, set all recordset and
connection objects to Nothing

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook