here you have to use the paging to load this amount of data, otherwise, your page performance either degrade or will not load completed the request. In this case, you should have to provide the search functionality because user always interested to have their record in second, user don't want to navigate and search on every page

Use paging in SPselect ID,Note from(select ID,Note, ROW_NUMBER() OVER (order by ID desc) as Pos from TestTable) as Twhere T.Pos > 1000 and T.Pos < 10030

https://msdn.microsoft.com/en-us/library/bb445504.aspxhttp://www.codeproject.com/Questions/468866/how-to-bind-lakh-records-in-gridview-within-few