Shulou(Shulou.com)06/03 Report--

This article will explain in detail the benefits of using connection pooling in programming development. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Connection pooling is a technique for creating and managing a buffer pool of connections that are ready to be used by any thread that needs them.

Connection pooling benefit

This connection "pooling" technique is based on the fact that for most applications, when they are dealing with a transaction that usually takes milliseconds to complete, they need only one thread that can access the JDBC connection. When no transaction is processed, the connection is idle. Instead, connection pooling allows idle connections to be used by other needed threads.

In fact, when a thread needs to use JDBC to operate on a GBase or other database, it requests a connection from the pool. When the thread finishes using the connection, return it to the connection pool so that it can be used by other threads that want to use it.

When a connection is "lent" from the pool, it is requested to be used exclusively by its thread. From a programming point of view, this is the same as when a user's thread calls DriverManager.getConnection () whenever it needs a JDBC connection, using connection pooling technology, you can end the thread by using a new or existing connection.

Connection pooling can greatly improve the performance of users' Java applications while reducing the use of all resources. The main advantages of connection pooling are:

Reduce connection creation time

Although GBase provides faster connection capabilities than other databases, creating new JDBC connections can still incur network and JDBC driver overhead. If this type of connection is used in a "circular" way, these expenses can be avoided.

Simplified programming mode

When using connection pooling, each individual thread can operate as if it had created its own JDBC connection, allowing users to use JDBC programming techniques directly.

Controlled use of resources

If the user does not use connection pooling, but creates a new connection whenever the thread needs it, the resource usage of the user's application will be very wasteful and may lead to exceptions under high load.

Note that each connection to the GBase has an expense on both the client and the server side (memory, CPU, context switching, and so on). Each connection places some restrictions on the resources available to the application and the GBase server. Whether or not these connections are doing useful work, a significant portion of these resources will still be used.

Connection pooling maximizes performance while keeping resource utilization below a certain level beyond which the application crashes rather than just slows down.

How connection pooling works

In practical application development, especially in WEB application system, if JSP, Servlet or EJB use JDBC to access data in the database directly, each data access request must go through the steps of establishing database connection, opening database, accessing data and closing database connection. Connecting and opening database is a resource-consuming and time-consuming task, if this kind of database operation occurs frequently. The performance of the system is bound to decline sharply, and even cause the system to crash. Database connection pool technology is the most commonly used way to solve this problem, in many application servers (for example: Weblogic,WebSphere,JBoss), basically provide this technology, without their own programming, but in-depth understanding of this technology is very necessary.

This is the end of the article on "what are the benefits of using connection pooling in programming development". I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.