Hi all,
Please guide us to improve initial load time of RadGrid databinding.
Our scenario is:
1. RadGrid has 7 bound columns and 33 GridTemplateColumns. (Setting column visible property 'false' for 25 GridTemplateColumns at runtime). So total display columns is 15 only.
2. Rendering data size 500KB.
3. It is taking more than 120 seconds to load data in grid.
here is the sample code:
Please guide us to improve initial load time of RadGrid databinding.
Our scenario is:
1. RadGrid has 7 bound columns and 33 GridTemplateColumns. (Setting column visible property 'false' for 25 GridTemplateColumns at runtime). So total display columns is 15 only.
2. Rendering data size 500KB.
3. It is taking more than 120 seconds to load data in grid.
here is the sample code:
| <telerik:RadGrid ID="RadGrid1" runat="server" Width="960px" AllowPaging="false" PagerStyle-AlwaysVisible="false" HeaderStyle-HorizontalAlign="center" BackColor="#e8eefa" HeaderStyle-Font-Size="8" AllowSorting="false" > |
| <ClientSettings Scrolling-UseStaticHeaders="true" > |
| <Scrolling FrozenColumnsCount="2" SaveScrollPosition="false" ScrollHeight ="350px"/> |
| </ClientSettings> |
| <MasterTableView NoMasterRecordsText="No Matching Record Exists" Name="Master" Width="960px" |
| DataKeyNames="PersonLocationId" EnableColumnsViewState="true" TableLayout="fixed" |
| > |
| <Columns> |
| <telerik:GridTemplateColumn UniqueName="PersonSelected" |
| HeaderStyle-Width="15px" ItemStyle-Width="100%" > |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn DataField="PersonName" UniqueName="Person" |
| HeaderStyle-Width="120px" ItemStyle-Width="100%" ItemStyle-HorizontalAlign="left"> |
| <ItemTemplate> |
| <asp:Label ID="lblPersonName" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.PersonName") %>'></asp:Label> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridBoundColumn datafield="Specialty" uniquename="Specialty" Visible="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn uniqueName="Day1" HeaderStyle-Width="35px" ItemStyle-Width="100%" > |
| </telerik:GridTemplateColumn> |
| ..... |
| ..... |
| <telerik:GridTemplateColumn uniqueName="Day31" HeaderStyle-Width="35px" ItemStyle-Width="100%" > |
| </telerik:GridTemplateColumn> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |