Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database pressure testing method

A pressure test and database technology, applied in the field of database testing, can solve problems such as the algorithm is not efficient enough, and achieve the effect of solving performance and stability

Inactive Publication Date: 2015-08-26
G CLOUD TECH
View PDF3 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

There are many factors that affect the software response speed, some are because the algorithm is not efficient enough; others may be affected by the number of concurrent users

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database pressure testing method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] See figure 1 As shown, a method for database stress testing of the present invention specifically includes the following steps:

[0018] Step 1, install the JMeter tool, configure the JAVA environment and start JMeter;

[0019] (1) First, you need to install the java environment. The first step is to download it from the JDK official website.

[0020] (2) To configure the java environment, right-click "Computer" -> Properties -> Advanced System Settings -> Environment Variables.

[0021] (3) System Variables -> New -> Variable Name: JAVA_HOME

[0022] Variable value: D:\Program Files\Java\jdk1.7.0_05;

[0023] Find the variable name in the system variables: Path, then select -> Edit, and add directly after the variable value:;%JAVA_HOME%\bin (note the symbol, there is a value in front, and the latter should be separated by a semicolon);

[0024] System Variables -> New -> (this one to be created) variable name: CLASSPATH variable value:

[0025] %JAVA_HOME%\lib;%JA...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The present invention relates to the technical field of database testing, and in particular relates to a database pressure testing method. According to the present invention, a test plan is newly created and a database JDBC configuration is provided, by using a JMeter tool; then a request is sent via the JDBC for testing; and finally a test result is collected via a graphic result. The method according to the present invention can well reflect whether a database object needs to be optimized, and can be widely applied for database performance testing for a software product.

Description

technical field [0001] The invention relates to the technical field of database testing, in particular to a database pressure testing method. Background technique [0002] When it comes to testing, the first thing that comes to people's minds is the testing of software correctness, which is often referred to as functional testing. But it is not enough for software to function correctly. In actual development, there are other non-functional factors that also play a decisive role, such as the response speed of the software. There are many factors that affect the software response speed, some are because the algorithm is not efficient enough; others may be affected by the number of concurrent users. At present, the database server is indispensable in most enterprise projects. The purpose of stress testing the database is to find out whether the database objects can effectively withstand the access from multiple users. These objects are mainly: indexes, triggers, stored proce...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/36G06F17/30
Inventor 何龙泉徐震宇孙傲冰季统凯
Owner G CLOUD TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products