Abstract: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.