Research on Query Optimization Method Based on Dameng
Qi Chen, Ming Zhong Ren, Tao Xia · 2022 IEEE 5th Advanced Information Management, Communicates, Electronic and Automation Control Conference (IMCEC) · 2022
The optimization technology of database query performance is studied based on Dameng. Office OA applications are used as the test environment, and python scripts are used to batch insert large amounts of data. A large number of experiments have been carried out on the four technologies of data table index, select statement optimization, paging query and parallel query. The test tools developed on easyops platform and Google Chrome developer tools have been used to analyze the data of database response and page loading speed of the test results, respectively. With the two as parameters of the test results, the impact of the four technologies on the database query performance is discussed. The results show that appropriate data table index, optimization of “*” and “limit” in SQL query statements, ID limited paging query and parallel query technology can greatly improve the response speed of the database.