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

5 Million Records

1 Answer 55 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Lester
Top achievements
Rank 1
Lester asked on 06 Oct 2013, 12:14 AM
I have a table with 5,355,113 records. I want to display them in a grid. I have a test application similar
to this: Link

The description of the example says: "allows you to handle millions of records within a few milliseconds",
but I'm getting the error displayed in the attached image.

What am I doing wrong?. The example linked before should be able to handle 5 million records? or, should
I handle the paging in code behind?

This is my ASPX code (No code behind):

<
telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="RadGrid1">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1" />
 
<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AutoGenerateColumns="False" PageSize="1"
    DataSourceID="LinqDataSource1">
    <PagerStyle Mode="NextPrevAndNumeric" />
     <MasterTableView TableLayout="Fixed">
        <Columns>
            <telerik:GridBoundColumn DataField="ID" HeaderText="ID" UniqueName="ID">
            </telerik:GridBoundColumn>
        </Columns>
 
    </MasterTableView>
</telerik:RadGrid>
 
<asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="WebApplication1.DAL.DataClassesDataContext" TableName="Cards" OrderBy="ID">
</asp:LinqDataSource>

Any help would be appreciated. Thanks

1 Answer, 1 is accepted

Sort by
0
Angel Petrov
Telerik team
answered on 10 Oct 2013, 06:28 AM
Hello Lester,

After researching the matter it seems that the problem is more related to the extraction of the data than the use of RadGrid(please examine this link). In order to verify this I would like to ask you to try and bind another control to the LinqDataSource and test whether the same problem occurs. If it does not please send us a runnable sample which replicates the issue so we could inspect it locally.

Regards,
Angel Petrov
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Tags
Grid
Asked by
Lester
Top achievements
Rank 1
Answers by
Angel Petrov
Telerik team
Share this question
or