When you hear about GridView control, the first thing that comes out of your mind is the default paging that comes with GridVew control. It’s great for demos and small databases but if you want to use it in a bigger site, you might need other options. This is because the default GridView control will have a massive performance drop in large databases.
GridView paging retrieves all the record frm SQL then displays it only when required. Thus you’ll see a massive performance drop if you use it in large sites. The best way to handle it is to use GridView control with ObjectDataSource control and specify the methods for manual paging.
Read the rest of the tutorial here: http://www.dotnetcurry.com/ShowArticle.aspx?ID=267