Method and device for detecting database performance

Abstract

The invention discloses a database performance detection method and device, wherein the method specifically includes: reading data from the memory, performing multiple operations on the database table according to the read data, and calculating the results corresponding to the multiple operations Write to the disk, and record the time for completing the multiple operations; wherein, the multiple operations include multiple insert operations, multiple query operations, and multiple update operations; the execution process of the multiple insert operations includes: using At least one transaction executes the multiple insertion operations on the database table; according to the recorded time for completing the multiple operations, a corresponding database performance detection result is obtained. The invention can improve the stability of the database performance detection result, and can display the user database performance detection result in real time through the click request of the user interface.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for detecting the performance of a database. Background technique [0002] With the rise of the mobile Internet, mobile terminals such as smartphones have gradually become one of the indispensable tools in people's daily life, and users' demand for purchasing mobile terminals has become increasingly strong. However, in the process of purchasing a mobile terminal, the most common problem that a user will encounter is: not knowing how well the performance of the mobile terminal to be purchased is. [0003] In response to the above problems, some existing detection software can detect the performance of the mobile terminal. These performances can specifically include: CPU integer performance, CPU floating point performance, 2D (two-dimensional, Two Dimensions) drawing performance, 3D (three-dimensional, Three Dimensions) Drawing performance, database performan...

AI Technical Summary

Problems solved by technology

However, in the process of purchasing a mobile terminal, the most common problem that users will encounter is: it is unclear how the performance of the mobile terminal to be purchased is.

After testing, it is found that the detection results obtained by the existing database performance detection methods fluctuate greatly in different detection environments; even for the same model, when different ROMs are used, there will be large differences in the detection results obtained , the difference in test results, that is, instability can easily lead to inaccurate test results

However, inaccurate database performance testing will affect the fairness of overall performance. For example, it is unfair that the overall performance score of low-end mobile phones is higher than that of mid-range mobile phones.

Images