This is a migrated thread and some comments may be shown as answers.

[Solved] Grid load test issue

0 Answers 10 Views
Grid
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Asterix
Top achievements
Rank 1
Asterix asked on 08 Nov 2011, 08:03 PM

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();
}

Tags
Grid
Asked by
Asterix
Top achievements
Rank 1
Share this question
or