[Solved] 5 Million Records

[Lester]

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

[Angel Petrov]

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