Access timeout data processing method and device

Abstract

The invention discloses an access timeout data processing method and device. The method includes acquiring the query attribute of an access request used for characterizing the type of the access request; acquiring the correspondence of the query attribute and the exceeding time, namely the time exceeding the preset access waiting time; determining the actual exceeding time of the access request according to the correspondence. By the aid of the method, the problems that in the prior art, if only one fixed exceeding time is estimated, all the query conditions are difficult to meet, a fixed exceeding time shared by all the query conditions is difficult to determine, even though the exceeding time is determined successfully, the system performance can be influenced are solved.

Description

Access timeout data processing method and device technical field The invention relates to the field of databases, in particular to a data processing method and device for access timeout. Background technique At present, in information systems, a large number of databases are used for data storage. When querying the database, the SQL language is generally used. When using the SQL language to query the database, in order to reduce the possibility of the database entering the deadlock state and reduce the burden on the database, it is generally necessary to set a timeout period. When the execution time of the SQL script exceeds the timeout period, the execution of the script is stopped. When the execution time of the SQL script does not exceed the timeout period, continue to execute the script. The timeout time has a great impact on the system. If the timeout time is set too short, it will cause a large number of SQL script execution timeouts, which will cause the system ...

AI Technical Summary

Problems solved by technology

The main purpose of the present invention is to provide a data processing method and device for access timeout, to solve the problem that if only a fixed timeout period is estimated in the related art, it is difficult to satisfy all query conditions, moreover, such a common query condition It is also difficult to determine the fixed timeout period, even if it can be successfully determined, it may affect the performance of the system

Images