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

Slow grid loading

1 Answer 96 Views

Grid

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

JedF asked on 28 Apr 2011, 01:42 PM

This is my grid.
I also use llblgen to populate the grid and it take to long.
I use onneeddatasource and it populates the IEnum fine but it take ages to render the grid.
There are over 400000 records in the message table.
This take ages to load.

<telerik:RadGrid AutoGenerateColumns="False" ID="RadGrid1"

DataSourceID="SqlDataSource1" AllowFilteringByColumn="True" AllowPaging="True"

AllowSorting="True" runat="server">

<PagerStyle Mode="NextPrevAndNumeric" />

<GroupingSettings CaseSensitive="false" />

<MasterTableView TableLayout="Fixed">

<Columns>

<telerik:GridBoundColumn HeaderText="Product name" DataField="MessageId" UniqueName="ProductName"

SortExpression="ProductName" HeaderStyle-Width="180px" FilterControlWidth="140px"

AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false" />

<telerik:GridBoundColumn HeaderText="Quantity per unit" DataField="Subject"

UniqueName="QuantityPerUnit" SortExpression="QuantityPerUnit" HeaderStyle-Width="110px"

FilterControlWidth="90px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains"

ShowFilterIcon="false" />

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AxxessRadConnectionString %>"

SelectCommand="SELECT * FROM [Message]"></asp:SqlDataSource>

Slow grid loading

1 Answer, 1 is accepted