HI, When the total record count get exceeded lets say 100000 its performance getting decreased. Could you please provide solution for this. How we can maintain the performance with large records with custom paging. Regards,

Hello Slin, 

Generally you could remove the GridDataSourceAction attribute. By setting it on the action you enable the grid to use its own logic to query the data based on the request send from the client. If you remove it you can manually handle the remote requests and based on what is passed in the query string manipulate your data manually and return the result you want to see in the grid. For example for paging you can get the current page and the page size from the query: 

            int currentPageIndex = Convert.ToInt32(this.Request.QueryString["page"]);

            int pageSize = Convert.ToInt32(this.Request.QueryString["pageSize"]); 

And then based on that build your own Json result and pass the data you want to send as json to the client.

Here’s an example action result that would return the data for the current page and the total records count to the grid when the GridDataSourceAction attribute is removed:

[ActionName("GridGetData")]

        public ActionResult GridGetData()

        {

            int currentPageIndex = Convert.ToInt32(this.Request.QueryString["page"]);

            int pageSize = Convert.ToInt32(this.Request.QueryString["pageSize"]);

 

            //lets assume this is the whole data source we want to bind to

            List<Products> list = new List<Products>();

            for (int i = 0; i < 100; i++)

            {

                list.Add(new Products() { ProductID = i, Name = "Product " + i, ListPrice = i, ModifiedDate = DateTime.Now.AddDays(i)});

            }

 

            //We'll need to manually get the data we want to pass to the client for the current page

            List<Products> currentData = list.Skip(currentPageIndex).Take(pageSize).ToList();

            DataModel model = new DataModel() { Records = currentData, TotalRecordsCount = 100 };    

 

            JsonResult result = new JsonResult();

            result.Data = model;  

          

            result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;

            return result;

        }

Note that in this case you’ll need to set:

ResponseDataKey("Records") and RecordCountKey("TotalRecordsCount") so the grid would be able to find those properties in the response json data.

 

I’ve attached a sample for your reference. Let me know if you have any questios.

 

Best Regards,

Maya Kirova

Developer Support Engineer II

Infragistics, Inc.

http://ko.infragistics.com/support

 

Hi Maya thanks for the quick reply,

I already have the datasourceurl set to an action on the controller and I have features.Paging().Type(OpType.Remote) set as well.

The problem is, is there anyway to have a different query be used for the totalRecordCount rather than have the infragistics do everything itself. The way it handles the select top pagesize works fine but the query that's being used to generate the count is taking up quite a bit of time because of all the joins it left in place and I can only imagine it will get worse as our database grows.

Thanks,

Slin