Method and system for achieving concurrent requests based on connection pool of lock

Abstract

The invention provides a method for achieving concurrent requests based on a connection pool of a lock, which comprises the following steps of: S1, setting the connection pool of the lock, the connection pool comprising a lock array and a connection array; s2, when an external site requests to access a database cache or service, firstly initializing a connection pool, and setting each lock in thelock array to be in an available state; s3, when an external site requests to access, calling an interface of the GetConnection to carry out connection to obtain an available connection, and setting the lock of the lock array corresponding to the connected connection array unit to be in a lock state; and S4, after the database cache or service is requested and a certain connection is used up, putting the connection back, that is, the lock of the lock array corresponding to the connected connection array unit is restored to the available state, so that concurrent execution of multiple requestsis realized, and the performance of the system is improved.

Description

technical field [0001] The invention relates to the technical field of computer communication, in particular to a method and system for realizing concurrent requests based on a lock-based connection pool. Background technique [0002] The core idea of ​​the current connection pool technology is: connection reuse. By establishing a database connection pool and a set of connection usage, allocation, and management strategies, the connections in the connection pool can be reused efficiently and safely, avoiding the need for database connections. The overhead of frequent establishment and shutdown. Among them, the allocation and release strategy of the connection pool is very important for the effective reuse of connections. At present, the reference counting (reference counting) method is generally used in the industry. Although this Reference Counting (reference counting) is simple and intuitive, it is convenient to implement, but it But there is a fatal flaw, that is, it is ...

AI Technical Summary

Problems solved by technology

Among them, the allocation and release strategy of the connection pool is very important for the effective reuse of connections. At present, the reference counting (reference counting) method is generally used in the industry. Although this Reference Counting (reference counting) is simple and intuitive, it is convenient to implement, but it But there is a fatal flaw, which is easy to cause memory leaks

That is, if there is a circular reference, then Reference Counting may cause a memory leak

Images