[Solved] Timeout when calling ToDataSourceResult

[Michael]

I am receiving a timeout error via an AJAX call when using Kendo with MVC.  The result set is a large set of records approx 250K with 14 fields though I would not expect this to timeout.  Any ideas why this might be happening?

public ActionResult Grid_Read([DataSourceRequest]DataSourceRequest request)

{

    var dbContext= new DataBaseContext();

 

    IQueryable<Report> ReportData = from ParentRecord in ParentTable

                  join ChildRecord in ChildTable on ParentRecord.Id equals ChildRecord.ParentId

                  select new ReportModel

                  {

                      FieldOne = ParentRecord.FieldOne,

                      FieldTwo = ParentRecord.FieldTwo,

                      FieldThree = ChildRecord.FieldThree

                  };

 

    DataSourceResult result = ReportData .ToDataSourceResult(request);

 

    return Json(result);

}

[Daniel]

Hello Michael,

Does the problem occur when returning JSON and the ToDataSourceResult is not used? With 250k records you will probably get an exception for exceeding the maximum JSON length in which case you should either use custom JSON result or paging.

Regards,
Daniel
the Telerik team