Efficient SQL Statement Execution Threads
DOI:
CSTR:
Author:
Affiliation:

Clc Number:

Fund Project:

  • Article
  • |
  • Figures
  • |
  • Metrics
  • |
  • Reference
  • |
  • Related
  • |
  • Cited by
  • |
  • Materials
  • |
  • Comments
    Abstract:

    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.

    Reference
    Related
    Cited by
Get Citation

洪承煜,杨尚琴,陈浩.一种高效的SQL语句执行线程.计算机系统应用,2014,23(1):162-165

Copy
Share
Article Metrics
  • Abstract:
  • PDF:
  • HTML:
  • Cited by:
History
  • Received:June 21,2013
  • Revised:July 22,2013
  • Adopted:
  • Online: January 26,2014
  • Published:
Article QR Code
You are the firstVisitors
Copyright: Institute of Software, Chinese Academy of Sciences Beijing ICP No. 05046678-3
Address:4# South Fourth Street, Zhongguancun,Haidian, Beijing,Postal Code:100190
Phone:010-62661041 Fax: Email:csa (a) iscas.ac.cn
Technical Support:Beijing Qinyun Technology Development Co., Ltd.

Beijing Public Network Security No. 11040202500063