摘要
在CMS系统查询中,影响查询效率最主要有两个方面:首先是设计合理高效的SQL查询脚本,合理使用索引、嵌套子查询、WHERE条件子句。其次是优化ADO数据访问。本文利用了存储过程优化CMS系统中查询模块对数据库的访问。通过一个实例说明如何利用存储过程提高查询效率。
In the process of CMS system query,there are two important factors which play great rules on searching efficiency. One is designing reasonable and effective SQL searching script,and a rational way to use index,nesting query and WHERE if-clause is in-cluded. The other is optimizing ADO data visit. And in this paper the visit of the CMS system query model to database is optimized in the stored procedure. At last an example is illustrated to increase searching efficiency with stored procedure.
出处
《微计算机信息》
北大核心
2008年第12期211-213,共3页
Control & Automation
基金
国家自然科学基金项目(50135010)
