一种高效的SQL语句执行线程

摘要

During the acquisition, processing and interpretation integrated software platform, there are a large number of SQL statements inevitably executed, while running these SQL statements, SQL statements that do not need to return occupy to a major proportion. This paper designs the SQL statements cache and SQL statements that do not need to return real-time put into this cache, and finally by designing the thread of executing SQL statements, SQL statements in the cache real-time process. This method does not only the separation of business and database operations, but also improves the business efficiency of requests for database operations.%在采集、处理、解释一体化软件平台中，不可避免地有大量的 SQL 语句执行，而在这些 SQL 语句执行中，不需要返回的SQL语句又占主要比例。通过设计SQL语句缓存区，并把不需要返回的SQL语句实时放入此缓存区，最后通过设计高效的执行线程，对此缓存区内的SQL语句进行实时的处理。这种方法既分离了业务与数据库操作，也提高了业务对数据库操作请求的效率。