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
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.