CodeSmith Community
Your Code. Your Way. Faster!

Connection Pooling, Locks and DB performance

Latest post 12-27-2006 4:29 PM by mike123. 1 replies.
  • 12-21-2006 2:49 PM

    • jenad1kr
    • Not Ranked
    • Joined on 04-03-2006
    • Posts 4
    • Points 80

    Connection Pooling, Locks and DB performance

    I am using nettiers 2.0 template with Oracle 10G. How do i find out if my nettiers methods actually release the DB resources  once execution is over? I am not sure if datareaders are disposed properly, is there any way to watch what is happening when a connection is killed, an ExecuteDataReader method is called and datareader object is closed? any pointers will help a lot. thanks in advance!
    • Post Points: 35
  • 12-27-2006 4:29 PM In reply to

    • mike123
    • Top 10 Contributor
    • Joined on 02-25-2005
    • Toronto, Ontario
    • Posts 734
    • Points 17,040

    Re: Connection Pooling, Locks and DB performance

    jenad1kr,

    Take a look here ADO.NET Connection Pooling Explained see if this helps ... also post your questions to one of these forums

    jenad1kr:
    I am using nettiers 2.0 template with Oracle 10G. How do i find out if my nettiers methods actually release the DB resources  once execution is over? I am not sure if datareaders are disposed properly, is there any way to watch what is happening when a connection is killed, an ExecuteDataReader method is called and datareader object is closed? any pointers will help a lot. thanks in advance!

    Mike Shatny
    --------------------------------------------------------------
    Member of the .netTiers team http://www.nettiers.com
    --------------------------------------------------------------

    Filed under: ,
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems