Data query processing method and device

Abstract

The embodiment of the invention discloses a data query processing method and device, and the method comprises the steps: carrying out the query of to-be-queried data according to a current query timeinterval, and obtaining the query execution time and query result data volume of the current query time interval; if the query execution time is greater than the time threshold, determining a first query time interval according to the query time interval, the query execution time and the time threshold; if the query result data volume is greater than the data volume threshold, determining a secondquery time interval according to the query time interval, the query result data volume and the data volume threshold; and further determining the updated query time interval, and continuously querying the to-be-queried data; and judging whether the query execution time and the query result data volume in the current query time interval meet the requirements or not through the time threshold and the data volume threshold, and if not, adjusting the query time interval in time to limit the queried data volume, thereby avoiding overflowing caused by excessive memory occupation and ensuring the normal operation of each program.

Description

technical field [0001] The embodiments of the present invention relate to the field of computer technology, and in particular to a data query processing method and device. Background technique [0002] With the rapid development of computer technology, the amount of data that computers can store is increasing. In the process of data processing, it is necessary to query the large-scale table data in the existing system. Usually, all the data is queried at once. Or use a fixed-length query step, but you can't control the amount of data you query, and you can't limit the size of the program memory, which is prone to insufficient memory and memory overflow. Contents of the invention [0003] Since the above-mentioned problems exist in the existing methods, the embodiments of the present invention propose a data query processing method and device. [0004] In the first aspect, the embodiment of the present invention proposes a data query processing method, including: [0005]...

AI Technical Summary

Problems solved by technology

[0002] With the rapid development of computer technology, the amount of data that computers can store is increasing. In the process of data processing, it is necessary to query the large-scale table data in the existing system. Usually, all the data is queried at once. Or use a fixed-length query step, but you can't control the amount of data you query, and you can't limit the size of the program memory, which is prone to insufficient memory and memory overflow.

Images