Lakshmi Thangaraj
Top achievements
Rank 1
Rank 1
Lakshmi Thangaraj
asked on 01 Dec 2010, 08:07 AM
Hai
I need to bind lacs of record to a radgrid. Instead of binding all records in need data source at i am binding only 10 records to the first page. When the user clicks on pagination link, i fetch the next set of rows from db and bind it to the radgrid. I pass the row start and ending position as argument to the database. It will work fine if the record count is less.When i increase the data the performance is slow. How can i increase the speed.
In SP i create a temp table to select the top rows And from the temptable i get the last 10 rows that i required for the particular page.
Is there any way to select the row between the particular row number?
Thanks
I need to bind lacs of record to a radgrid. Instead of binding all records in need data source at i am binding only 10 records to the first page. When the user clicks on pagination link, i fetch the next set of rows from db and bind it to the radgrid. I pass the row start and ending position as argument to the database. It will work fine if the record count is less.When i increase the data the performance is slow. How can i increase the speed.
In SP i create a temp table to select the top rows And from the temptable i get the last 10 rows that i required for the particular page.
Is there any way to select the row between the particular row number?
Thanks
1 Answer, 1 is accepted
0
Hello Lakshmi,
Given the described scenario, the performance bottleneck is within the DataAcess layer of your application and is not related to the RadGrid control. Depending on your scenario, you should look for ways to optimize the database-server performance.
Greetings,
Tsvetoslav
the Telerik team
Given the described scenario, the performance bottleneck is within the DataAcess layer of your application and is not related to the RadGrid control. Depending on your scenario, you should look for ways to optimize the database-server performance.
Greetings,
Tsvetoslav
the Telerik team
Browse the vast support resources we have to jumpstart your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.