摘要
本文针对钢铁企业铁前MES海量级数据库系统SQL查询效率低的问题,通过索引创建、等价改写、业务逻辑优化方法手段,使得数据库性能显著地提升,用户体验感增强。由数据库服务器性能指标(CPU占用率、逻辑读、响应时间)分析计算可知,铁前MES数据库整体性能提升了4倍。
In this paper, aiming at the low SQL querying efficiency in massive database system of Ironmaking MES in the Iron and steel enterprise, database performance is significantly improved and user experience is enhanced through SQL optimization methods such as index creation, equivalent rewriting and transaction logic optimization.According to the analysis and calculation of the database server performance indicators(CPU usage, logical read, response time),the overall performance of MES database has been improves by 4 times.
作者
郭凌宙
Guo Lingzhou(Fujian SanSteel(Group)Co.,Ltd.,Sanming 365000,Fujian)
出处
《福建冶金》
2022年第4期55-59,共5页
Fujian Metallurgy
关键词
海量级
优化
执行计划
数据库治理
索引
mass level
optimization
execution plan
database governance
index