ASP. NET 2.0-select dataset or datareader

 

In the previous articleArticleHow to make good use「 Make good usePerformancemodeAttribute 」( Http://www.cnblogs.com/liminzhang/archive/2006/12/18/595332.html ), Which caused a lot of repercussions.Web formWeb pages should be usedDatasetOrDatareaderAs a real data source.

 

Further on the chart1UsedDatareaderAndDatasetAdvantages and disadvantages. In general,DatareaderNot onlyDatasetFast, inIISThe memory used on the server is also small. We recommend that you useDatareader. Otherwise, you must useDatasetAnd bear all its negative effects.

 

performancemode properties		disadvantages
datareader	fast	cache, paging, and dynamic sorting are not supported.
dataset	supports caching, paging, and dynamic sorting	slow