Lsit View and Data Pager using MySql retreiving the huge number of records

Posted by Varaprasadm.84 under ASP.NET on 7/6/2010 | Views : 2262 | Status : [Member] | Replies : 1
I am using List View and Data Pager where the search results will contains lakhs of records. so if i use the ListView it is taking so much time to load the page what is the best technique for retrieving the small amount of data using Data Pager and needs to improve the performance.

and the search results must display the original count but needs to bind the few data and based on the paging retrieves the data from Data Pager.

where i have to reduce and enhance the scenario to get more number of records @ a time

either in SP or in the Page.Aspx.CS

if it is possible can i have the sample code how to acheive more performance by using the MySQL.

Thanks in Advance, Vara Prasad.M

Vara Prasad.M


Posted by: Jayakumars on: 3/18/2013 [Member] [MVP] Bronze | Points: 25

refer this

Mark as Answer if its helpful to you

Varaprasadm.84, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response