Home
Explore
Tags
Contribute
Home
»
VB.NET
»
VB.NET ADO.NET
ADO.NET connection pooling works in VB.NET
Posted in
VB.NET
|
VB.NET ADO.NET
on
November 02, 2019
Tags:
This article is about how connection pooling makes the process of connecting to ADO.NET data sourcse more efficient.
This article is about how connection pooling makes the process of connecting to ADO.NET data sourcse more efficient.
3500
The basic idea behind connection polling is that a pool of database connections is available to one or more users of a database. When a user attempts to connect to the database, ADO.NET checks to see if an existing connection can be retrieved from a
connection pool.
If a program requests a connection and one isn't available in the pool, a new connection is created unless the maximum number of the connection for the pool are already in use. In that case, the program must wait for a connection to become available.
Each connection pool contains a limited number of connections. Because of that, if a large number of user attempt to access the database using the same connection string, it's likely that some users will have to wait for a connection.
Importance of connection pooling
In developing an application that will run in a Web-based or multi-tier environment, pooling becomes very important. Making connections to the database can be one of the application's most time-consuming activities. Maintaining connections to the database in the resource state of the Web server can create scalability problems because all users are forced through the same connection object (not to mention that Web servers are almost by definition "stateless"). Opening a new connection on every page of a Web server is bad because it's slow. MDAC pooling provides a way to get the best of both scenarios: a limited number of connections (just enough to match your system's current load) without introducing a scalability bottleneck.
Connection pooling programs let you reduce database-related overhead when it's the sheer number of physical connections dragging performance down. This is particularly important on Windows, where system limitations prevent large number of connections.
How does the pool maintenance thread work?
The behaviour of the pool maintenance thread is determined by the value of four properties of the connection pool:
Aged timeout:
The amount of time a connection will be open.
Minimum connections:
The minimum number of connections the Connection Manager will keep in a connection factory's free pool.
Reap time:
How often the pool maintenance thread will run.
Unused timeout:
How long a connection will remain in the free pool before it is closed.
Related Articles
ADO .NET Connection Pooling in VB .NET
ADO .NET Handling Events & Connection Events in VB.NET
DataSet Events Working in VB.NET
WPF Grid Using VB.NET
Introduction of DataGrid Control in VB.NET
ADO.NET Data Adapter in VB.NET
ADO.NET Table and Column Mapping in VB.NET
ADO.NET Updating the Database in VB.NET
DataView and DataViewManager Events working in VB.NET
Windows Forms Controls in VB.NET
Categories
ACTIVE DIRECTOTRY IN VB.NET
ALGORITHMS AND VB.NET
ARRAY IN VB.NET
ASP.NET AJAX IN VB.NET
ASP.NET USING VB.NET
ASSEMBLIES IN VB.NET
COM INTEROP IN VB.NET
CRYPTOGRAPHY IN VB.NET
CRYSTAL REPORTS IN VB.NET
DATABASE & DBA
DEPLOYMENT IN VB.NET
DESIGN & ARCHITECTURE
DIRECTX WITH VB.NET
ENTERPRISE DEVELOPMENT
FILE IN VB.NET
GAMES IN VB.NET
GDI+ IN VB.NET
GENERAL
LINQ WITH VB.NET
MOBILE DEV IN VB.NET
MULTITHREADING IN VB.NET
NETWORKIN WITH VB.NET
OFFICE AND VB.NET
PRINTING IN VB.NET
REMOTING IN VB.NET
REPORTS IN VB.NET
SECURITY IN VB.NET
SILVERLIGHT USING VB.NET
Speech in VB.NET
STRING IN VB.NET
TABLET PC
VB.NET ADO.NET
VB.NET ARTICLE
VB.NET EXCEPTION HANDLING
VB.NET FAQ
VB.NET HOW DO I
VB.NET LANGUAGE
VB.NET TUTORIALS
VB.NET WINDOWS SERVICES
VBA
VISUAL BASIC 10
VISUAL BASIC LANGUAGE
WCF WITH VB.NET
WEB CONTROL IN VB.NET
WEB DEV IN VB.NET
WEB FORM WITH VB.NET
WEB SERVICES IN VB.NET
WINDOWS CONTROLS
WINDOWS FORMS IN VB.NET
WORKFLOW IN VB.NET
WPF IN VB.NET
XAML IN VB.NET
XML IN VB.NET
More Articles
How to Connect Oracle Database with VB.NET
Get a Database Table properties programmatically in VB.NET
How To Load Data From Database Into DataGridView In VB.NET
Insert data in ADO.NET with the CommandBuilder object in VB.NET
How To Fill Data Into Dataset In VB.NET
Retrieve Column Name From A Database Table In VB.NET
Match Value From Database User Control in VB.NET
Stored procedure in Connected model in VB.NET
Read SQL Data Table In ADO.NET Database And Store Data In ListBox In VB.NET
Store file in specific folder using directory class in VB.NET
ADO.NET Insert command in VB.NET
ADO.NET Drop command In VB.NET
Display data using DataAdapter of disconnected model in VB.NET
Simple data access component with Connection, Command and DataReader Classes in VB.NET
ADO.NET call Stored Procedure In VB.NET
Use CommandBehaviour.CloseConnection to return multiple rows in VB.NET
ADO.NET Update command in VB.NET
Bind dataset with label control in VB.NET
ADO.NET command object in VB.NET
Read the data with the DataReader object in VB.NET
Asp.net external CSS in VB.NET
ADO.NET Use ODBC.NET Data Provider in VB.NET
Working With The ODBC .NET Data Provider in VB.NET
Bind dataset with label control in VB.NET
SQL Server Database Programmatically Create in VB.NET
VB.NET Accessing MySQL Database
Retrieve rows from a database table in VB.NET
Understanding ODBC .NET Data Provider in VB.NET
Bind a DropDownList control with database in VB.NET
Copy DataTable to Another Using ImportRow in VB.NET
Generic Data Access Component Writing in VB.NET
Using the ADO Recordset in VB.NET
ADO.NET Delete command in VB.NET
Working with Views in VB.NET
Find specific record from database table in VB.NET
ADO.NET CommandBuilder Object in VB.NET
ADO.NET Connection object in VB.NET
Executing Stored Procedure Programmatically in VB.NET
ADO.NET DataAdapter in VB.NET
Stored Procedures working in VB.NET
DataView and DataViewManager Events working in VB.NET
ADO.NET DataAdapter in VB.NET
XmlDataDocument Events Working in VB.NET
DataTable Events Working in VB.NET
ADO.NET connection pooling works in VB.NET
DataSet Events Working in VB.NET
Accessing Excel Databases using ADO.NET in VB.NET
DataSet Group Implementing in VB.NET
ADO.NET Using ADO RecordSet in VB.NET
ADO.NET From Windows DNA's Perspective in VB.NET
© 2020 DotNetHeaven. All rights reserved.
TERMS & CONDITIONS
|
CONTACT US
|
REPORT ABUSE