Database connection control management method and device
A connection control and management method technology, which is applied in the field of database connection control management methods and devices, can solve problems such as program crashes, memory increase, and efficiency reduction, and achieve the effects of improving utilization, execution efficiency, and use efficiency
Inactive Publication Date: 2011-11-16
SUZHOU CODYY NETWORK SCI & TECH
View PDF3 Cites 4 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] However, the above method has the following defects: (1) When there are a large number of database operations, the large number of database connections established cannot be released in time, causing memory to rise, and in severe cases, the program will crash; (2) After the database connection is established, it needs to open Connection, it takes a long time to open the connection. When there are a large number of concurrent operations on the database, the execution efficiency of the database will drop significantly; (3) After opening the database connection, the connection is only released after the SQL statement is executed, and the database connection resources are not recycled. lead to reduced efficiency
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0012] Hereinafter, the present invention will be described in detail with reference to the drawings and examples. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other.
[0013] figure 1 Shown is a flow chart of the database connection control management method provided according to the preferred embodiment of the present invention. Such as figure 1 As shown, the database connection control and management method provided by the preferred embodiment of the present invention includes steps 101-105. In step 101, the database execution process receives a database data request from the database scheduling process. In step 102, the database execution process determines the type of the database operation request. In step 103, the control process invokes a corresponding number of connections according to the type of the database operation request and the calling strategy ...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention provides a database connection control management method and device. The method comprises the following steps of: receiving a database operation request by a database execution process from a database dispatcher process; judging the type of the database operation request by the database execution process; calling a corresponding number of connections by a control process according to the type of the database operation request and a calling strategy so as to execute the database operation request; after the connections execute the database operation request, placing the connections in an open state back to a database connection stack by the database execution process for next calling; and closing the corresponding number of connections in the open state in the database connection stack by the control process according to a closing strategy.
Description
technical field [0001] The invention belongs to database access technology, in particular to a database connection control management method and device. Background technique [0002] Today, a large number of applications need to access the database to obtain the required data. Generally, connections are used in database applications to interact with the database. In practice, a database connection must be established for each application request. The specific method is as follows: firstly, establish the database connection; secondly, open the database connection; thirdly, use the connection to execute the SQL statement; finally, close the database connection and release the database connection resources. [0003] However, the above method has the following defects: (1) When there are a large number of database operations, the large number of database connections established cannot be released in time, causing memory to rise, and in severe cases, the program will crash; (2)...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 胡加明
Owner SUZHOU CODYY NETWORK SCI & TECH