基于ASP.NET的Web数据分页实现与性能优化

Web data paged implementation and optimization based on ASP.NET

动态网页设计中分页显示数据有多种方法,其中存储过程按需分页最好:它依靠二分思想,将整个待查询记录分为2部分,使扫描的记录量减少一半,进而通过对数据表及查询条件进行优化,实现了存储过程的优化.对几种存储过程分页方式的性能测试结果也表明二分优化存储过程更为高效.

There are several methods to display paged data in dynamic web page design,but stored procedure for demanding pages is best.It relies on dichotomous approach thinking,dividing the entire query record into two parts,reducing the amount of scanning records to half,and then through optimizing the data table and query condition to archive the optimization of the stored procedure.Performance testing for these several store procedure data paged,experiment result showed that performance of dichotomous optimization store procedure for data paged was high.