The application of Optimization on Stored procedure of CMS System Query

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.