Data exporting method and device

Abstract

The invention is suitable for the technical field of data processing, and provides a data exporting method and device, and the method comprises the steps: obtaining all data exporting tasks associatedwith a data exporting triggering task if a preset data exporting triggering condition is met; counting the number of tasks of the data export task, and detecting the number of threads in a local thread pool; dividing idle threads in the thread pool into query threads and lead-out threads based on the number of the tasks and the number of the threads; and calling a query thread to extract target data associated with each data export task from the database, and writing the target data into a preset task data document through the export thread. Hardware resources in the equipment can be dividedinto different types, one part executes data query operation, and the other part executes data export operation, so that the situation that CPU occupation is increased instantaneously due to the factthat all the hardware resources are used for data write-in operation is avoided, and the stability of the equipment is improved.

Description

technical field [0001] The invention belongs to the technical field of data processing, and in particular relates to a data export method and equipment. Background technique [0002] As all kinds of documents are digitized, the amount of data contained in databases is also increasing. In daily work and life, users often need to query and export corresponding data through databases, so how to effectively export the required data is particularly important. In particular, when the amount of data to be exported is large, most databases often need to query the data to be exported from the database when responding to the task of exporting data, and then execute the data export operation after querying all target data , so that in the process of data export, due to the huge amount of written data, the CPU usage will increase, occupy a large amount of hardware resources, and reduce the stability of the device, and during the data query period, a large amount of data write resources...

AI Technical Summary

Problems solved by technology

[0003] In view of this, the embodiment of the present invention provides a data export method and device to solve the existing data export response technology. When the amount of data to be exported is large, due to the huge amount of written data, it will It leads to increased CPU usage, takes up a lot of hardware resources, reduces the stability of the device, and during the data query period, a large amount of data is written to resources and idles, reducing the utilization of resources.

Images