This question is locked. New answers and comments are not allowed.
Hello,
There is an issue we are facing with the telerik grid control.
It handles records of the order of 100,000 gracefully, but returns this error -"Error! The requested URL returned 500 - error" beyond that.We have a filter based on from date and to date but the order of records in production for even a month are quite huge.
Was wondering if anybody has faced similar issues?
Thanks,
Asterix
Below is the code, we are using,
<script type="text/javascript"> function onDataBinding(e) { e.data = { StartDate: $('#StartDate').val(), EndDate: $('#EndDate').val(), SearchString: $('#Search').val() }; } </script> @{ Html.Telerik() .Grid<MessageAudit_AllTopics>() .BindTo(Model.Data) .Name("MessageHistory") .DataKeys(keys => keys.Add(c => c.Sequence)) .ToolBar(toolbar => toolbar.Template( @<text> <table> <tr> <td width="50"> @using (Html.BeginForm("SelectAll", "MessageHistory")) { <input type="submit" name="HistorySelectAllButton" value="Select All" disabled="disabled" /> } </td> <td width="50"> @using (Html.BeginForm("DeleteSelected", "MessageHistory")) { <input type="submit" name="HistoryDeleteSelectedButton" value="Delete Selected" disabled="disabled" /> } </td> <td width="100"> Start Date @Html.Telerik().DateTimePicker().Name("StartDate").Value(Model.StartDate) </td> <td width="100"> End Date @Html.Telerik().DateTimePicker().Name("EndDate").Value(Model.EndDate) </td> <td width="400"> Search In Message: @Html.TextBox("Search", "",new { style = "width:100%" }) </td> </tr> </table> </text>)) .Columns(columns => { columns.Template(@<text><input name="checkedRecordsMessageHistory" type="checkbox" value="@item.Sequence" title="checkedRecords" @if (item.Checked) { <text>checked="checked"</text> } /></text>).Title("").Width(36).HtmlAttributes(new {style = "text-align:center"}); columns.Bound(m => m.ActionDateUTC).Title("Date").Width(175); columns.Bound(m => m.TopicRoot).Title("Root Topic").Width(50); columns.Bound(m => m.Topic ).Title("Sub Topic").Width(50); columns.Bound(m => m.Party).Title("Party Id").Width(50); columns.Bound(m => m.Semantic).Title("Semantic").Width(50); columns.Bound(m => m.Machine).Title("Machine").Width(100).HtmlAttributes(new { nowrap = true}); var popUp = "javascript:showModalDialog('" + Url.Action("MessageDetails", "MessageHistory", new { Id = "<#=Sequence#>" }) + "',null,'dialogWidth:1200px;dialogHeight:900px;center=yes;scroll:yes;resizable=yes;');return false;"; columns.Bound(m => m.Sequence).ClientTemplate(Html.ActionLink("Details...", "MessageDetails", "MessageHistory", new { Id = "<#=Sequence#>" }, new { target = "_blank", onclick = popUp }).ToString()).Title("Details").Filterable(false).Sortable(false); } ) .Sortable() .Groupable() .ClientEvents(e => e.OnDataBinding("onDataBinding")) .EnableCustomBinding(true) .DataBinding(dataBinding => dataBinding.Ajax().Select("_CustomBinding", "MessageHistory")) .Editable(editing => editing.Mode(GridEditMode.PopUp)) .Resizable(resizing => resizing.Columns(true)) .Pageable(pager => pager.Position(GridPagerPosition.Both).Total(Model.Total).PageSize(20)) .Filterable(filtering => filtering.Enabled(true)).Render(); }