RadGrid Performance Issue

[Pardha Saradhi]

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.

[Cori]

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.