What is the association of connection?
Connection Association is a date for managing users' connections who ask questions in databases. Although many users may not notice this if there are a large number of users looking for access to the application server on which the database is located, the clear volume of the connection can be almost impossible for the server to maintain a good connection with all connections at these times. Software engineering, which allows connection association, allows the server to manage the connection well regardless of the high volume of connections that create queries, and allows response to these queries with partial seconds.
Connection must have an identical configuration to be included in the Connection Fund, so most of the server connection programs have different fonds of the connection running simultaneously. When the user tries to connect, he is assigned to a pool with similar configurations if there is space.If there is no space, the queue's request is assigned as soon as it comes. The user does not have to be aware that he is in the queue, but may simply notice that the database seems to be slow in response to the question; However, in the Back Office of Database Management Systems, there is a scan of funds that find users a place to find an open connection. Most connecting programs have a list of maximum users' list and a minimum amount of time settings for which the connection can remain inactive before dropping the connection and the availability is returned to the fund.
When creating a connecting fund, a certain number of connections are added to the fund. To be considered active, the pool needs a minimum number of objects. These connection objects are availability seats that connect the connection to the pool, and are created and added to the pool as needed to the maximum permissions of the pool. Since users are satisfied with itICH questioning and releases their connection object, objects are returned to the Fund Connection Programs to use another user or the same user when they return.
One factor that can slow the response time in conjunction with the connection is what is called fragmentation of funds fragmentation. The database management system verifies the users and then is in the queue or assignment by existing association objects discharges the memory and the stricter system design often clarifies the problem with too much anabasis. Design of the integrated security system based on Windows -based programs in many connectivity programs requires only one user user within the Fund of Fund. This can be clarified by creating multiple pools that meet other requirements that must be answered in parallel.
If the Pooling Connection program detects that the user has been idle above the set time or interrupted, the connection object will return to the fund as an invalid object. IfD Server decreases when the connection is valid, the connection can still be downloaded, although the connection fund is not aware of the interrupted connection. Activex Connection-Pool programs will then usually clean up the Fund as soon as the server is restarted.