Database connection: Difference between revisions

Content deleted Content added
External links: I add a related article in the external link section. I hope this article will also help readers to fix database error issue.
Tags: Reverted Visual edit
Reverting edit(s) by 45.127.247.65 (talk) to rev. 1050015250 by Sauer202: Addition of unnecessary/inappropriate external links (RW 16.1)
Line 11:
Database connections are finite and [[time complexity|expensive]] and can take a disproportionately long time to create relative to the operations performed on them. It is inefficient for an application to create, use, and close a database connection whenever it needs to update a database.
 
[[Connection pool]]ing is a technique designed to alleviate this problem. A pool of [https://wpblog.info/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/ database connections] can be created and then shared among the applications that need to access the database.
 
The connection object obtained from the connection pool is often a wrapper around the actual database connection. The wrapper understands its relationship with the pool, and hides the details of the pool from the application. For example, the wrapper object can implement a "close" method that can be called just like the "close" method on the database connection. Unlike the method on the database connection, the method on the wrapper may not actually close the database connection, but instead return it to the pool. The application need not be aware of the connection pooling when it calls the methods on the wrapper object.
Line 37:
==External links==
* [http://ConnectionStrings.com ConnectionStrings.com]
*[https://wpblog.info/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/ Fix error establishing a database connection]
 
[[Category:Databases]]