What is better to do, and if you could, please include the pros and cons along with your opinions:
1) Open the connection to the database as late as possible and end it as early as possible, and do this a total of 5 times in one page_load.
2) Open the connection to the database as late as possible and KEEP it OPEN until the last SQL Query has been retreieved, then close it.
3) Split the connections; Keep one Connection open for 2 or 3 query executes and then close, then open another and execute the remaining.
I believe number 2 is the best, as if 100 people access the page at once, that would create 100 connections in the matter of seconds, rather than option one of creating 500 connections in the matter of seconds. But does leaving the connections open use up more memory and drain more performance than just having 500 connections? Or does it really matter? Let me know.