database connection method

[cjam4]

what is more efficient, opening the database once in the beginning of the page then closing it at the end of the page, or opening the db connection each time you need it.

for example:

i have a page that executes 50 queries. is it better to open the db, execute the queries, then close it, or to open and close the db 50 times?

thanks

[Gokou]

the quicker you can open and close it the better....if u need to do multiple quieries and need some info all the way through ur page, wack the info into an array with rs.getrows()

[DaveMaxwell]

Open the database connection ONCE. Open and close the recordsets EACH and everytime. Use getrows when you can to speed up the process significantly....

[jofa]

http://msdn.microsoft.com/library/de...ml/asptips.asp
Tip 8: Acquire Resources Late, Release Early