The embodiment of the invention provides a to-be-processed work order optimization method and
system. According to the method, firstly, corresponding to-be-handled models are created for to-be-handled work order types, index fields covering necessary information are configured for all the models, and it is ensured that data storage is adaptive to efficient query; thirdly, designing an exclusive target interface for each work order type, and establishing a precise data interaction channel; secondly, writing the data into a
database, and asynchronously writing the data into a
search engine with a data writing function to lay a data foundation for efficient query; then, the query source logic of the to-be-optimized application page is changed into
search engine query from
database query, so that migration of a query mode is achieved; and finally, configuring a
system main switch and each work order type independent switch, performing
database query during default closing and performing
search engine query during opening, and greatly reducing
database query pressure by virtue of strong full-text search and real-time analysis capabilities of a search engine while flexible switching is performed, so that the query efficiency is remarkably improved.