This is a migrated thread and some comments may be shown as answers.

RadGrid Performance Issue

1 Answer 31 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Pardha Saradhi
Top achievements
Rank 1
Pardha Saradhi asked on 29 Jul 2010, 01:23 PM

HI,

I have Oracle database with 3,00,000 of records with around 500 users will be accessing the same data in single shot from multiple countries, so i am unable to handle performance issue since i am following the following mechanism

 

objSearchContactResultsDO =

BusinessFactory.SearchContact().SearchContact(objSearchDO);

 

grdSearchContact.DataSource = objSearchContactResultsDO.ContactResultsDO;

objSearchContactResultsDO :- is getting the data from database and pushing to grid.

I am unable to do filter operations of telerik grid since i am using grdsearchcontact.Databind() method.

so i am capturing my fileter conditions from telerik grid and sending to database and that result i am filling with "OnneedDatasource" mentod. so soritng also taking long time since i am doing soring with database.
 
when i do search and sorting, it is doing postback the page and taking long time to give the result.

So Please adivce me the best mechanism to handle bulk data with multiple users.

Thanks in Advance.

1 Answer, 1 is accepted

Sort by
0
Cori
Top achievements
Rank 2
answered on 29 Jul 2010, 02:02 PM
You don't need to constantly pass the filters to your database, since I believe they are performed by the RadGrid control itself, the same for sorting. The RadGrid doesn't send the filters or sort to the datasource, it performs those operations in memory.

So try just setting your datasource in the OnNeedDataSource event of the RadGrid and don't pass the filters to see if that improves your performance.

I hope that helps.
Tags
Grid
Asked by
Pardha Saradhi
Top achievements
Rank 1
Answers by
Cori
Top achievements
Rank 2
Share this question
or