i am facing performance issue while using the datagrid in my project, i am writing my code here please correct me if i am writing something wrong.
i am using sql server 2000 in which i have a table containing around 600000 records and i can not put any indexing on this table as this is the staging table for me .
now To show these record on front end i am using gridview with Allowpaging = "True" now in the PageIndexChanged event i have to again hit the database and bind the grid which results very slows performance as just to change the page i have to read 600000 records again and again, i am giving some idea below what i am doing
Public Void BindgridView()
//do database connection
//fill the dataset through adapter
Gridview.datasource = dataset();
protected void GridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
GridView1.PageIndex = e.NewPageIndex;
Any idea how can i imrove the performance, Please help me out..
View Complete Post