摘要
针对分界开关监控系统数据库实时状态表数据量急剧增大造成查询效率降低并且维护困难的问题,提出了对此类表进行分区的优化方案.详细阐述了表分区优化处理的过程,并通过分区窗口的滑动对实时状态表过时数据进行删除.通过大量测试数据,对比了分区前后的查询时间.测试结果表明,采用表分区技术能够显著提高查询效率,改善数据库性能.
In face of problems such as low query speed and difficult maintenance caused by data volumes increasing in real-time state table of boundary load switch monitoring system database, this paper proposes data table partition optimization method, expounds the implementation process in detail, and removes obsolete data by sliding partitioned window. Through a large number of test data, the query efficiency of a same table before and after partitioning are compared. Results indicate that using the technology of table partition can shorten data query time dramatically and improve the stability of the database.
出处
《计算机系统应用》
2016年第2期235-238,共4页
Computer Systems & Applications
关键词
数据库性能优化
表分区
索引分区
监控系统
database optimization
table partition
index partition
monitoring system