摘要 |
Connection information for open database connections is stored or "cached" in a connection manager at the database client. Therefore, even when a query is complete and the connection between the client and server is released, the manager maintains the database connection open. When a new query arrives at the client, the connection manager compares the connection information in the query to the corresponding information stored for each open connection. If there is a match and the connection is not in use, the already open connection is used for the new query. If there is no match, a new connection is opened until a predetermined limit of the number of connections is reached. When the limit is reached, an open connection which is not in use is closed and a new connection is established. In accordance with a preferred embodiment, a "free" list of open connections which are not in use is maintained so that a quick comparison can be made with the incoming query information.
|