Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    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

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    26,561
    Thanks
    80
    Thanked 4,495 Times in 4,459 Posts
    Modify the data access layer so it doesn't close the connection each time??
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    New to the CF scene
    Join Date
    May 2008
    Location
    US
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you. I don't want to change the DAL unless its really necessary. I have tried to write a SP to club a few of the insert/select statements which help me in eliminating some of the open and close statements from my code.

    I'll probably have to come up with a better way eventually, as I will have to start integrating transactions and much more to that page.
    ---
    Freeze


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •