Classic ASP Discussion

Print Page | Close Window

Adocon.open

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=379
Printed Date: 29 March 2026 at 2:55am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Adocon.open

Posted By: Gullanian
Subject: Adocon.open
Date Posted: 21 February 2003 at 7:15am

When developing ASP software, is it best to recycle one adocon connection throughout the whole page, or is it better to open then close, open the close throughout the page?

Replies:

Posted By: Mart
Date Posted: 21 February 2003 at 8:00am

recycle

Posted By: MorningZ
Date Posted: 21 February 2003 at 8:21am

and make sure to close it at the end of the page

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: dolby71
Date Posted: 21 February 2003 at 9:26am

Recycle of course!
If you don't close it later, after couple of times thr DB may crash and corrupt...

Posted By: WebWiz-Bruce
Date Posted: 21 February 2003 at 11:05am

It's best to only have one connection to the db, also if you can use the same recordset through out the page, by closing it after each query, but don't drop the object it will also speed up the processing of the page quite allot.

but DON'T forget to release all objects at the end of the page or you will slowly use up all your sites allocated memory and your site will get slower and slower till the server resets itself.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Gullanian
Date Posted: 22 February 2003 at 12:13pm

Thanks guys! youve helped me a lot

Ill post here when my project is done, im sure youll want to see it ;) Should be good fun