CodingForums.com - View Single Post - Multiple open close database connections in one page

mrfreeze81 · 09-30-2010, 04:51 AM

I'm trying to create a website using ASP.NET 2.0, where one page during the process of Page_Load has to do multiple table reads from a single database schema. I have a Data Access Layer, which for each select statement returns a DataTable. This however has to open and close the database connection for each retrieval. (I use an ODBC connection to connect to my MySQL database).

I'm currently looking at 4-5 table select statements with open and close connections per page load. I am worried about the overload when the user pool accessing this page grows.

Is this effective programming or would I have to go for stored procs where there could be one open and close.

Thanks in advance,

09-30-2010, 04:51 AM	PM User \| #1
mrfreeze81 New to the CF scene Join Date: May 2008 Location: US Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts	Multiple open close database connections in one page I'm trying to create a website using ASP.NET 2.0, where one page during the process of Page_Load has to do multiple table reads from a single database schema. I have a Data Access Layer, which for each select statement returns a DataTable. This however has to open and close the database connection for each retrieval. (I use an ODBC connection to connect to my MySQL database). I'm currently looking at 4-5 table select statements with open and close connections per page load. I am worried about the overload when the user pool accessing this page grows. Is this effective programming or would I have to go for stored procs where there could be one open and close. Thanks in advance, __________________ --- Freeze