CN116150031A - Program performance test early warning method, device, equipment and storage medium - Google Patents

Program performance test early warning method, device, equipment and storage medium Download PDF

Info

Publication number
CN116150031A
CN116150031A CN202310231874.7A CN202310231874A CN116150031A CN 116150031 A CN116150031 A CN 116150031A CN 202310231874 A CN202310231874 A CN 202310231874A CN 116150031 A CN116150031 A CN 116150031A
Authority
CN
China
Prior art keywords
statement
test
execution
program
early warning
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310231874.7A
Other languages
Chinese (zh)
Inventor
常萧颖
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Agricultural Bank of China
Original Assignee
Agricultural Bank of China
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Agricultural Bank of China filed Critical Agricultural Bank of China
Priority to CN202310231874.7A priority Critical patent/CN116150031A/en
Publication of CN116150031A publication Critical patent/CN116150031A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Preventing errors by testing or debugging software
    • G06F11/3668—Software testing
    • G06F11/3672—Test management
    • G06F11/3684—Test management for test design, e.g. generating new test cases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Preventing errors by testing or debugging software
    • G06F11/3668—Software testing
    • G06F11/3672—Test management
    • G06F11/3688—Test management for test execution, e.g. scheduling of test suites
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

The invention discloses a program performance test early warning method, a program performance test early warning device, program performance test equipment and a storage medium. The method comprises the following steps: acquiring a program to be tested and a test case corresponding to the program to be tested; executing the test case through the program to be tested, and acquiring test statement execution information based on extraction processing of an execution information extraction tool; and generating program performance early warning information based on the test statement execution information. By analyzing the execution information characteristics of the test statement, whether the program to be tested has a performance problem or not is determined, so that the test efficiency can be improved, and the test cost is reduced.

Description

Program performance test early warning method, device, equipment and storage medium
Technical Field
The present invention relates to the field of program testing technologies, and in particular, to a program performance testing early warning method, device, equipment and storage medium.
Background
Software testing is needed before the application program is on line so as to optimize the application program, thereby ensuring the correctness and stability of the application program.
With respect to software testing, the problems faced with performance and functional aspects are different. The functional aspect can be easily found by executing the test case, and is mainly characterized in that the functional aspect is not in accordance with the requirement document and the program is misplaced. The discovery of performance is complex, and a series of performance tests are required to be performed and the analysis is performed according to the tested system data to discover the program problem.
The current method for testing program performance mainly relies on testing manually. The test is performed manually, so that the time is long, the cost is high, and the tester is required to have abundant performance test experience.
Disclosure of Invention
The invention provides a program performance test early warning method, a device, equipment and a storage medium, which can be used for determining whether a program to be tested has a performance problem or not by analyzing the execution information characteristics of test sentences, so that the test efficiency can be improved, and the test cost can be reduced.
According to one aspect of the invention, a program performance test early warning method is provided. The method comprises the following steps: acquiring a program to be tested and a test case corresponding to the program to be tested; executing the test case through the program to be tested, and acquiring test statement execution information based on extraction processing of an execution information extraction tool; and generating program performance early warning information based on the test statement execution information.
According to another aspect of the invention, a program performance test early warning device is provided. The device comprises: the program to be tested obtaining module is used for obtaining the program to be tested and the test case corresponding to the program to be tested; the test statement execution information acquisition module is used for executing the test case through the program to be tested and acquiring test statement execution information based on the extraction processing of the execution information extraction tool; and the program performance early warning information generation module is used for generating program performance early warning information based on the test statement execution information.
According to another aspect of the present invention, there is provided an electronic apparatus including:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein, the liquid crystal display device comprises a liquid crystal display device,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the program performance test pre-warning method according to any one of the embodiments of the present invention.
According to another aspect of the present invention, there is provided a computer readable storage medium storing computer instructions for causing a processor to execute the program performance test pre-warning method according to any one of the embodiments of the present invention.
According to the technical scheme, the program to be tested and the test case corresponding to the program to be tested are obtained. And executing the test case by the program to be tested, acquiring test statement execution information based on the extraction processing of the execution information extraction tool, and generating program performance early warning information based on the test statement execution information. By analyzing the characteristics of the execution information of the test statement, whether the program to be tested has a performance problem or not can be determined, so that the test efficiency is improved, and the test cost is reduced.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of a program performance test early warning method according to a first embodiment of the present invention;
FIG. 2 is a diagram of a program performance test early warning interface screen/schematic/architecture suitable for use in accordance with a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a program performance test early warning device according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device implementing a program performance test and early warning method according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example 1
Fig. 1 is a flowchart of a program performance test early warning method according to an embodiment of the present invention, where the method may be performed by a program performance test early warning device, and the program performance test early warning device may be implemented in hardware and/or software, and the program performance test early warning device may be configured in an electronic device. As shown in fig. 1, the method includes:
s101, acquiring a program to be tested and a test case corresponding to the program to be tested.
The program to be tested may refer to an application program to be tested for performance. The test cases can be formulated in advance according to the program to be tested, wherein the test cases can be used for running test of the program to be tested, and the performance condition of the program to be tested is determined based on the test result.
S102, executing the test case through the program to be tested, and acquiring test statement execution information based on the extraction processing of the execution information extraction tool.
Wherein the execution information extraction tool is an open source software tool (such as P6 spy). The execution information extraction tool can track database operation and record the three-dimensional execution statement information of the calling database in the running process of the program. The test statement execution information may refer to execution information of the program to be tested in executing the test case call database. Illustratively, the test statement execution information may include executed SQL (Structured Query Language, structured query language database) statements.
Specifically, the program to be tested is run simultaneously with the execution information extraction tool. The test case is executed by the program to be tested, and the execution information extraction tool extracts the execution process of the program to be tested, so that test statement execution information can be obtained. In the technical scheme of the invention, the content of the extraction processing of the execution information extraction tool can be recorded in a log file (for example, sys.log), and the log file is determined as the test statement execution information.
It should be noted that, before the program to be tested, the database configuration file of the program to be tested may be modified, so that the execution information extraction tool may perform extraction processing on the execution process of the program to be tested.
S103, generating program performance early warning information based on the test statement execution information.
Specifically, analysis and comparison processing is carried out on the acquired test statement execution information, and program performance early warning information is generated according to the test statement execution information under the condition that preset comparison conditions are met. In the technical scheme of the invention, the test statement execution information can be recorded in a log file (such as a warning. Txt), and program performance early warning information can be generated according to the log file. Program performance early warning information is distributed to a mailbox of a tester, and the program performance early warning information is distributed to terminal equipment of the tester in an alarm mode.
According to the technical scheme, the program to be tested and the test case corresponding to the program to be tested are obtained. And executing the test case by the program to be tested, acquiring test statement execution information based on the extraction processing of the execution information extraction tool, and generating program performance early warning information based on the test statement execution information. By analyzing the characteristics of the execution information of the test statement, whether the program to be tested has a performance problem or not can be determined, so that the test efficiency is improved, and the test cost is reduced.
On the basis of the above embodiments, the generating program performance early warning information based on the test statement execution information includes: determining a test database table corresponding to the test statement execution information according to the test statement execution information; and generating program performance early warning information according to the test database table corresponding to the test statement execution information.
The test database table may refer to data table information in test statement execution information.
Specifically, analyzing and extracting the test statement execution information, acquiring a test database table in the test statement execution information, analyzing and processing the test database table, and generating program performance early warning information based on an analysis result.
In the technical scheme of the invention, the related information in the test database table can be recorded in a log file (for example, table. Txt), and the log file is determined as the test database table.
On the basis of the above embodiments, the generating program performance early warning information according to the test database table corresponding to the test statement execution information includes: calculating the total test data in the test database table; and generating program performance early warning information based on the test database table and the total test data under the condition that the total test data is smaller than the preset data.
The preset data amount may be a data amount preset according to experience of a tester. The preset data amount may also be the total amount of data in the database table corresponding to the online application program. The online application may be the base application for adding the program to be tested.
Specifically, the total test data recorded in the test database table is calculated, and the total test data is compared with the preset total data. And under the condition that the total test data is smaller than the preset data, the condition that the test data for testing is insufficient is indicated, the performance of the program to be tested cannot be fully verified, and program performance early warning information is generated according to a test database table and the total test data.
In the embodiment of the invention, the test orders (such as tens of thousands, millions and tens of millions) corresponding to the total amount of the test data recorded in the test database table can be calculated, and the comparison processing is performed on the test orders and the preset orders corresponding to the preset total amount of the data. And under the condition that the test order of magnitude is smaller than the preset order of magnitude, generating program performance early warning information according to the test database table and the total test data amount so as to remind debugging personnel to increase the test data amount and retest, thereby improving the accuracy of program performance test.
Example two
Fig. 2 is a flowchart of a program performance testing and early warning method according to a second embodiment of the present invention, where program performance early warning information generated based on the test statement execution information is further refined based on the above embodiment. As shown in fig. 2, the method includes:
s201, acquiring a program to be tested and a test case corresponding to the program to be tested;
s202, executing the test case through the program to be tested, and acquiring test statement execution information based on extraction processing of an execution information extraction tool;
s203, determining database execution sentences corresponding to the test sentence execution information according to the test sentence execution information.
The database execution statement may refer to an execution statement of a calling database in the test statement execution information.
Specifically, analyzing and extracting the test statement execution information to obtain a database execution statement in the test statement execution information.
S204, generating program performance early warning information according to the database execution statement corresponding to the test statement execution information.
Specifically, the analysis and comparison processing is carried out on the sentences of the database, and program performance early warning information is generated based on analysis and comparison results.
According to the technical scheme provided by the embodiment of the invention, the database execution statement corresponding to the test statement execution information is determined, and the program performance early warning information is generated according to the database execution statement, so that the comparison and investigation can be performed according to the specific execution statement, the efficiency of determining the performance problem of the program to be tested by a tester is improved, and the manual investigation cost is reduced.
Illustratively, generating program performance early warning information according to the database execution statement corresponding to the test statement execution information includes: determining an execution plan and execution statement content corresponding to the database execution statement according to the database execution statement corresponding to the test statement execution information; and generating program performance early warning information based on the execution statement content and/or the execution plan corresponding to the database execution statement.
Wherein, the execution plan may refer to a specific execution scheme in the database execution statement. The execution statement content may refer to specific content in the database execution statement.
Specifically, analysis and extraction processing is carried out on the database execution statement, and an execution plan and execution statement content corresponding to the database execution statement are obtained. And analyzing the content of the execution statement, generating program performance early warning information based on the analysis result, analyzing the execution plan, and generating program performance early warning information based on the analysis result, or analyzing the content of the execution statement and the execution plan, and generating program performance early warning information based on the analysis result.
Illustratively, the generating program performance early warning information based on the execution plan corresponding to the database execution statement includes: performing plan analysis on the execution plan, and determining the index condition of the execution plan; and generating program performance early warning information based on the database execution statement under the condition that the execution plan does not use an index.
Specifically, the execution plans corresponding to the database execution sentences are analyzed, the use index condition of the execution plans is determined, and program performance early warning information is generated based on the database execution sentences under the condition that the execution plans do not use indexes. In the embodiment of the invention, the database table structure is fully designed when the database system is designed, the future development quantity of the system needs to be fully estimated, whether the index is hit or not needs to be confirmed for the database statement used in the program, and the full rationality evaluation needs to be carried out under the condition of no index building. Whether the database statement used in the program hits the index is paid attention to, and meanwhile, the existing index is possibly invalid due to the fact that the database statement is newly added and modified in the running process of the system. The targeted index is designed for online transactions, and when there are multiple query conditions, a composite index can be established.
Illustratively, the generating program performance early warning information according to the content of the execution statement corresponding to the database execution statement includes: determining whether the content of the execution statement contains a preset statement or not based on a regular matching method; and generating program performance early warning information based on the database execution statement under the condition that the execution statement content contains the preset statement.
For example, the preset sentence may refer to specific execution sentence contents, such as an exist sentence and a like sentence.
Specifically, whether the content of the execution statement contains a preset statement or not is searched and determined through a regular matching method, the fact that the query function needs to be called for multiple times is indicated when the content of the execution statement contains the preset statement is determined, the performance efficiency of the preset statement needs to be concerned, and program performance early warning information is generated according to the database execution statement in the case.
Illustratively, the preset statement includes an in () statement; the generating program performance early warning information based on the database execution statement comprises the following steps: determining whether the content of the preset sentence is empty; and generating program performance early warning information based on the database execution statement under the condition that the content of the preset statement is determined to be empty.
The preset statement may further include an in () statement. If the preset statement is the in () statement, confirming whether the content is possibly empty, and avoiding the problem of database hard analysis caused by the empty content.
Specifically, based on the regular matching method, the search determines whether the content of the execution sentence contains a preset sentence. And determining whether the content of the preset statement is empty or not under the condition that the content of the execution statement is determined to contain the preset statement. When the content of the preset statement is empty, the statement execution statement can be executed according to the database to generate program performance early warning information, so that the problem of hard analysis of the database caused by the empty content is avoided, and the program analysis performance is improved.
Example III
Fig. 3 is a schematic structural diagram of a program performance testing and early warning device according to a third embodiment of the present invention. As shown in fig. 3, the apparatus includes: a program to be tested acquisition module 301, a test statement execution information acquisition module 302 and a program performance early warning information generation module 303. Wherein, the liquid crystal display device comprises a liquid crystal display device,
the program to be tested obtaining module 301 is configured to obtain a program to be tested and a test case corresponding to the program to be tested;
a test statement execution information acquiring module 302, configured to execute the test case by the program to be tested, and acquire test statement execution information based on extraction processing of an execution information extracting tool;
and the program performance early warning information generating module 303 is configured to generate program performance early warning information based on the test statement execution information.
According to the technical scheme, the program to be tested and the test case corresponding to the program to be tested are obtained. And executing the test case by the program to be tested, acquiring test statement execution information based on the extraction processing of the execution information extraction tool, and generating program performance early warning information based on the test statement execution information. By analyzing the characteristics of the execution information of the test statement, whether the program to be tested has a performance problem or not can be determined, so that the test efficiency is improved, and the test cost is reduced.
Optionally, the program performance pre-warning information generating module 303 includes a test statement execution information analyzing unit and a program performance pre-warning information generating unit. Wherein, the liquid crystal display device comprises a liquid crystal display device,
the test statement execution information analysis unit is used for determining a test database table and a database execution statement corresponding to the test statement execution information according to the test statement execution information;
and the program performance early warning information generating unit is used for generating program performance early warning information according to the test database table and/or the database execution statement corresponding to the test statement execution information.
Alternatively, the program performance pre-warning information generation unit may be specifically configured to:
calculating the total test data in the test database table;
and generating program performance early warning information based on the test database table and the total test data under the condition that the total test data is smaller than the preset data.
Optionally, the program performance early warning information generating unit includes a database execution statement analyzing subunit and a program performance early warning information generating subunit. Wherein, the liquid crystal display device comprises a liquid crystal display device,
the database execution statement analysis subunit is used for determining an execution plan and execution statement content corresponding to the database execution statement according to the database execution statement corresponding to the test statement execution information;
and the program performance early warning information generation subunit is used for generating program performance early warning information based on the execution statement content and/or the execution plan corresponding to the database execution statement.
Optionally, the program performance early warning information generating subunit may be specifically configured to perform a plan analysis on the execution plan, and determine an index condition of use of the execution plan;
and generating program performance early warning information based on the database execution statement under the condition that the execution plan does not use an index.
Optionally, the program performance early warning information generating subunit may be specifically configured to determine, based on a regular matching method, whether the content of the execution statement includes a preset statement;
and generating program performance early warning information based on the database execution statement under the condition that the execution statement content contains the preset statement.
Optionally, the preset statement includes an in () statement; the program performance early warning information generation subunit can be specifically used for determining whether the content of the preset statement is empty;
and generating program performance early warning information based on the database execution statement under the condition that the content of the preset statement is determined to be empty.
The program performance test early warning device provided by the embodiment of the invention can execute the program performance test early warning method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.
Example IV
Fig. 4 shows a schematic diagram of the structure of an electronic device 10 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 4, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.
Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as method program performance test pre-warning.
In some embodiments, the method program performance test pre-warning may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as the storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more of the steps of the method program performance test pre-warning described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the method program performance test pre-warning in any other suitable manner (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

Claims (10)

1. The program performance test early warning method is characterized by comprising the following steps of:
acquiring a program to be tested and a test case corresponding to the program to be tested;
executing the test case through the program to be tested, and acquiring test statement execution information based on extraction processing of an execution information extraction tool;
and generating program performance early warning information based on the test statement execution information.
2. The method of claim 1, wherein generating program performance pre-warning information based on the test statement execution information comprises:
determining a test database table and a database execution statement corresponding to the test statement execution information according to the test statement execution information;
and generating program performance early warning information according to the test database table and/or the database execution statement corresponding to the test statement execution information.
3. The method according to claim 2, wherein generating program performance pre-warning information according to the test database table corresponding to the test statement execution information includes:
calculating the total test data in the test database table;
and generating program performance early warning information based on the test database table and the total test data under the condition that the total test data is smaller than the preset data.
4. The method according to claim 2, wherein generating program performance pre-warning information according to the database execution statement corresponding to the test statement execution information comprises:
determining an execution plan and execution statement content corresponding to the database execution statement according to the database execution statement corresponding to the test statement execution information;
and generating program performance early warning information based on the execution statement content and/or the execution plan corresponding to the database execution statement.
5. The method of claim 4, wherein generating program performance pre-warning information based on the execution plan corresponding to the database execution statement comprises:
performing plan analysis on the execution plan, and determining the index condition of the execution plan;
and generating program performance early warning information based on the database execution statement under the condition that the execution plan does not use an index.
6. The method of claim 4, wherein generating program performance pre-warning information according to the content of the execution statement corresponding to the database execution statement comprises:
determining whether the content of the execution statement contains a preset statement or not based on a regular matching method;
and generating program performance early warning information based on the database execution statement under the condition that the execution statement content contains the preset statement.
7. The method of claim 6, wherein the preset statement comprises an in () statement; the generating program performance early warning information based on the database execution statement comprises the following steps:
determining whether the content of the preset sentence is empty;
and generating program performance early warning information based on the database execution statement under the condition that the content of the preset statement is determined to be empty.
8. The utility model provides a program performance test early warning device which characterized in that includes:
the program to be tested obtaining module is used for obtaining the program to be tested and the test case corresponding to the program to be tested;
the test statement execution information acquisition module is used for executing the test case through the program to be tested and acquiring test statement execution information based on the extraction processing of the execution information extraction tool;
and the program performance early warning information generation module is used for generating program performance early warning information based on the test statement execution information.
9. An electronic device, the electronic device comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein, the liquid crystal display device comprises a liquid crystal display device,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the program performance test pre-warning method of any one of claims 1-7.
10. A computer readable storage medium storing computer instructions for causing a processor to execute the program performance test pre-warning method according to any one of claims 1 to 7.
CN202310231874.7A 2023-03-10 2023-03-10 Program performance test early warning method, device, equipment and storage medium Pending CN116150031A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310231874.7A CN116150031A (en) 2023-03-10 2023-03-10 Program performance test early warning method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310231874.7A CN116150031A (en) 2023-03-10 2023-03-10 Program performance test early warning method, device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN116150031A true CN116150031A (en) 2023-05-23

Family

ID=86356305

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310231874.7A Pending CN116150031A (en) 2023-03-10 2023-03-10 Program performance test early warning method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN116150031A (en)

Similar Documents

Publication Publication Date Title
CN115598505A (en) Chip detection method, device, equipment and storage medium
CN116089258A (en) Data migration test method, device, equipment, storage medium and program product
CN115599769A (en) Data migration method and device, electronic equipment and storage medium
CN115687406B (en) Sampling method, device, equipment and storage medium for call chain data
CN115048352B (en) Log field extraction method, device, equipment and storage medium
CN115794744A (en) Log display method, device, equipment and storage medium
CN115455091A (en) Data generation method and device, electronic equipment and storage medium
CN115599679A (en) Test rule base updating method and device, electronic equipment and storage medium
CN115344495A (en) Data analysis method and device for batch task test, computer equipment and medium
CN116150031A (en) Program performance test early warning method, device, equipment and storage medium
CN114443802A (en) Interface document processing method and device, electronic equipment and storage medium
CN114693116A (en) Method and device for detecting code review validity and electronic equipment
CN113377924A (en) Data processing method, device, equipment and storage medium
CN115098405B (en) Software product evaluation method and device, electronic equipment and storage medium
CN116070601B (en) Data splicing method and device, electronic equipment and storage medium
CN117271373B (en) Automatic construction method and device for test cases, electronic equipment and storage medium
CN115794473A (en) Root cause alarm positioning method, device, equipment and medium
CN118012936A (en) Data extraction method, device, equipment and storage medium
CN117724981A (en) Test report generation method, device, equipment and storage medium
CN115617680A (en) User experience test case generation method, device, equipment and storage medium
CN114896418A (en) Knowledge graph construction method and device, electronic equipment and storage medium
CN116401269A (en) Data query method and device, electronic equipment and storage medium
CN114443493A (en) Test case generation method and device, electronic equipment and storage medium
CN116303578A (en) Query expression processing method, device, equipment and storage medium
CN117668192A (en) Data processing method, device, equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination