MCQs Test!! VB Basic Test !! Essentials of VB !! Creating User Services !! function !! Anatomy !! GK March-2019 !! DATA TYPES IN JAVA !! Classes ,Constructor ,Methods,Inheritance !! Ecology-I !! Biology 2019 !! Gk april 2019 !! Biology (living world) !! Plant anatomy !! CELL STRUCTURES AND FUNCTION !! General biology !! Human physiology !! Data structure !! Ecology-II !! GK TEST !! Reproduction in plants !! Human reproduction !! The ABC of C !! Operating system set1 !! Operating system set2 !! Gk and current affairs !! Animal kingdom !! Number system !! Animal kingdom-II !! Gk TEST-III !! Number series !! Microorganisms !! Interview question in c !! Time and Work !! Percentage !! General history !! Average !! Cells !! Locomotion and Movement !! paging !! Bacteriology !! Page replacement policy !! Secondary memory and Disk scheduling !! Introduction of Nervous System and neurons !! Plant harmones !! Transport and Mineral Nutrition in Plants !! Neurotransmitters !! Modern Indian History !! Photosynthesis in Plants !! Modern Indian History-II !! Plant respiration !! Environment & Biodiversity !! Environment & Biodiversity - II !! Algae, Bryophytes, Pteridophytes !! Area !! Cricket !! Days of the Year (India and the World) !! Plant Pathology - I !! Indian Transport System !! Plant Pathology - II !! Aptitude !! Biology !! Botany !! C language !! Computer Science !! Core Java !! Gate !! GK !! Mysql !! Operating system !! Physics !! VB-Visual Basic !! Zoology


ADO.NET Projects

ADO.NET Project 1

ADO.NET Examples


Previous Home Next

A connection pool is a set of database connections .Connection pool are available for an application to use and it is using for enhanced performance.

Connection pooling is also usefull for sharing resources. Connection pooling is used to handle the performance of executing commands on a database and it needs a connection to that database to be established before executing a command , .Connection pooling is used with applications that do not have a state. State is a presence between instances. ASP pages are consider stateless because they do not share data between themselves. Stateless applications benefit from connection pooling because they can not hold a connection open by themselves.Connection pooling is also usefull for sharing resources.

ConnectionPooling parameter

These are four parameters that control most of the connection pooling behavior

    Max Pool Size: The maximum size of our connection pool. Default is 100.

    Min Pool Size: Initial number of connections which will be added to the pool upon its creation. Default is 0.

    Connect: Timeout Controls the wait period in seconds when a new connection is requested, if this timeout expires, an exception will be thrown. Default is 15 seconds.

    Pooling: Controls if your connection pooling on or off. Default as you may've guessed is true. Read on to see when we may use Pooling=false setting.


Using ADO within Active Server Pages

To use connection pooling with ASP, we can use ADO objects as our database interface and have connection pooling turned on for IIS 3.0.

Code For Connection pooling

"initial catalog=emp; Min Pool Size=20;Max Pool Size=500;
           data source=localhost;Connection Timeout=30; 
                              Integrated security=sspi"
Previous Home Next