Open AccessResearch on Performance Optimization Technology of Complex Equipment Software Database
Author(s) -
Bo-Jiang Liu,
Lei Wu,
Wei He,
Xinyu Han,
Longli Tang
Publication year - 2021
Publication title -
iop conference series. materials science and engineering
Language(s) - English
Resource type - Journals
eISSN - 1757-899X
pISSN - 1757-8981
DOI - 10.1088/1757-899x/1043/2/022022
Subject(s) - database , database tuning , computer science , database testing , database design , database schema , database theory , database server , physical data model , software , view , distributed database , database model , operating system
Complex equipment software usually uses a database to store data. In order to enable it to run stably and efficiently during use, it is necessary to ensure the performance of database access. How to design and manage the database reasonably and optimize the database query has attracted much attention. This article studies the database access performance problems of MySQL equipment used by complex equipment software, studies database optimization techniques, and provides a database optimization solution for the database access delay problems that occur during project operation. Reduced waste of resources, thereby improving the efficiency of system database access, and solving the problem of system access to the database delay.