mvc 5 timeout

Question

Hi, In mvc 5, I got a time out error. I need to display 40,000 records. Thanks, -Neelima

Syed Shanu · Answer

Hi, Check this links hope this will help you. http://forums.asp.net/t/1971659.aspx?MVC+4+Entity+FrameWork+Large+Dataset+paging+kendo+grid http://stackoverflow.com/questions/13710246/kendo-ui-grid-with-large-data-set http://www.telerik.com/forums/virtual-scroll-paging

neel k · Answer

first time 40,000 records loading correctly when i click 2nd page again loading 40,000 records and showing out of memory exception.

Ramesh Maruthi · Answer

Hi Neelima, So in this line dt = ds.Tables[0] can you see 40 k records here ?? If your answer is yes Can you please see whether 10k records is also causing problem, by limiting your data-set to 10k as mentioned below . dt = ds.Tables[0] ; dt = dt.AsEnumerable().Skip(0).Take(10000).CopyToDataTable();

neel k · Answer

I am trying this below link , I am struck in the middle . can any one help me. its very urgent. http://www.codeproject.com/Articles/19284/Export-large-data-from-Gridview-and-Datareader-to

neel k · Answer

I can post my controller code and view code, can you please change the code, I don't know threading concept. Controller code: public ActionResult RunReports(int? id) { DomainContext CurrentLoginUser = ActiveDirectory_AccessModel.GetUserDetails(); // Username var userDetails = (from c in db.SP_GR_Get_Userdetails(CurrentLoginUser.DisplayName) select c.user_roles).FirstOrDefault(); if (userDetails == null) { return RedirectToAction("NoAccess"); } var runResult = (from c in db.tbl_GR_Reports where c.Report_ID == id select c).SingleOrDefault(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); if (runResult != null) { Microsoft.Practices.EnterpriseLibrary.Data.Database salesworldDbConn = new SqlDatabase(runResult.Db_Connection); DbCommand cmd = salesworldDbConn.GetSqlStringCommand(runResult.Query); try { ds = salesworldDbConn.ExecuteDataSet(cmd); } finally { cmd.Dispose(); salesworldDbConn = null; } if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } } return View(dt); } View Code: @model System.Data.DataTable @{ ViewBag.Title = "RunReport"; Layout = "~/Views/Shared/_Layout.cshtml"; } $(document).ready(function () { $("#export").click(function (e) { var grid = $("#grid").data("kendoGrid"); grid.saveAsExcel(); e.preventDefault(); }); }); @(Html.Kendo().Grid(Model) .Name("grid") .Scrollable() .Columns(columns => { columns.AutoGenerate(column => { column.Width = "100px"; }); //columns.AutoGenerate(true); }) .HtmlAttributes(new { style = "width: 900px;" }) //.Scrollable() .Groupable() .Filterable() .Sortable(sortable => sortable.AllowUnsort(true).SortMode(GridSortMode.MultipleColumn)) //.Pageable(pageable => pageable // .PageSizes(true) // ) .Resizable(resize => resize.Columns(true)) .DataSource(dataSource => dataSource .Ajax() //.PageSize(20) .ServerOperation(false) ) ) Export to Excel

Ramesh Maruthi · Answer

Can you break the task by using threading into 4 parts as 1 part 10,000 records , and write to excel file.

neel k · Answer

Thanks for reply, I need to display 40,000 records and export these records to Excel. When I am trying to display the records i got system out of memory exception.

Ramesh Maruthi · Answer

Hi Nelima, Can you elaborate ur issue a little more. Where did you got the time out issue ??

mvc 5 timeout

Answers (8)