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

Efficient SQL Statement Execution Threads

作　　者：洪承煜[1] 杨尚琴[1] 陈浩[1] 

机构地区：[1]中国石化石油物探技术研究院,南京211103

出　　处：《计算机系统应用》2014年第1期162-165,共4页Computer Systems & Applications

摘　　要：在采集、处理、解释一体化软件平台中,不可避免地有大量的SQL语句执行,而在这些SQL语句执行中,不需要返回的SQL语句又占主要比例.通过设计SQL语句缓存区,并把不需要返回的SQL语句实时放入此缓存区,最后通过设计高效的执行线程,对此缓存区内的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语句 线程 缓存区 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]