Hi Telerik Team,
I'm new to radgrid and i have an issue with grid loading time is more than a minute event less number or none..
So, I have gone throught at db level every thing is fine and it is taking 1 second while data retrival at query level.
may it possiable with radGrid to slow down the process?
If so, let me know with optimization tips at grid level..
Code:
<telerik:RadGrid ShowGroupPanel="true" AutoGenerateColumns="false" ID="GrdJobList"
Skin="Vista" AllowFilteringByColumn="false" AllowSorting="True" ShowFooter="True"
runat="server" GridLines="None" AllowPaging="true" PageSize="10" OnSelectedIndexChanged="GrdJobList_SelectedIndexChanged">
<PagerStyle Mode="NextPrevNumericAndAdvanced" AlwaysVisible="true" />
<ExportSettings HideStructureColumns="True" FileName="ServiceSummaryJobs" ExportOnlyData="true"
IgnorePaging="true" OpenInNewWindow="true" />
<MasterTableView ShowGroupFooter="true" AllowMultiColumnSorting="true" GroupLoadMode="Server"
GroupsDefaultExpanded="true" Name="MainTable"
TableLayout="Fixed">
<Columns>
<telerik:GridTemplateColumn UniqueName="RadioButtonTemplateColumn" HeaderStyle-Width="30px">
<ItemTemplate>
<asp:RadioButton id="RadioButton1" OnCheckedChanged="RadioButton1_CheckedChanged"
AutoPostBack="True" runat="server">
</asp:RadioButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="../../Files/Images/icons/icoView.gif"
UniqueName="ViewButton" CommandName="ViewCommand" HeaderStyle-Width="30px">
</telerik:GridButtonColumn>
<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="../../Files/Images/icons/icoAuthorise.gif"
UniqueName="AuthoriseButton" CommandName="AuthoriseCommand" HeaderStyle-Width="25px">
</telerik:GridButtonColumn>
<telerik:GridBoundColumn DataField="Id" HeaderText="Id" HeaderStyle-Width="60px"
FilterControlWidth="20px">
</telerik:GridBoundColumn>
<%-- <telerik:GridHyperLinkColumn DataTextField="Id" HeaderText="Job Id" HeaderStyle-Width="60px" FilterControlWidth="20px" DataNavigateUrlFields="Id" DataNavigateUrlFormatString="javascript:openViewJobPopUp('{0}');" >
</telerik:GridHyperLinkColumn>
<telerik:GridTemplateColumn HeaderText="Job Id" HeaderStyle-Width="60px" FilterControlWidth="20px">
<ItemTemplate>
<dns:DotNetSmithPopBtn CommandName="popupViewJobCommand" ID="btnPopViewJob" BackColor="WhiteSmoke" ForeColor="blue" runat="server" Text='<%#Eval("Id")%>' PopupURL="~/Pages/Jobs/PopupQuickJobInfo.aspx" PopupURLParams='<%# "JobId="+Eval("Id").ToString()%>' Height="22px" Width="40px" />
</ItemTemplate>
</telerik:GridTemplateColumn> --%>
<telerik:GridDateTimeColumn DataField="ReceivedDate" HeaderText="Worked On" DataFormatString="{0:dd-MMM-yyyy}"
HeaderStyle-Width="70px">
</telerik:GridDateTimeColumn>
<%-- <telerik:GridBoundColumn DataField="ReceivedDate" HeaderText="Worked On" DataFormatString="{0:dd-MMM-yyyy}"
HeaderStyle-Width="130px">
</telerik:GridBoundColumn>--%>
<telerik:GridBoundColumn DataField="ContactName" HeaderText="Customer" SortExpression="ContactName"
HeaderStyle-Width="100px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PersonName" HeaderText="Requested By" HeaderStyle-Width="200px"
Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SiteName" HeaderText="Site" SortExpression="SiteName"
UniqueName="SiteName" HeaderStyle-Width="100px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="LocationDesc" HeaderText="Location" SortExpression="LocationDesc"
UniqueName="LocationDesc" HeaderStyle-Width="200px" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SerialNo" HeaderText="Serial No" SortExpression="SerialNo"
HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CustomerAssetNo" HeaderText="Asset No" SortExpression="CustomerAssetNo"
HeaderStyle-Width="90px" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EquipmentNo" HeaderText="Eqp No" SortExpression="EquipmentNo"
HeaderStyle-Width="70px" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ModelNo" HeaderText="Model No" SortExpression="ModelNo"
FilterControlWidth="60px" HeaderStyle-Width="70px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PurchaseOrderNo" HeaderText="Purchase Order"
FilterControlWidth="60px" SortExpression="PurchaseOrderNo" HeaderStyle-Width="70px">
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="Job Total (Ex-GST)" HeaderStyle-Width="70px">
<ItemTemplate>
<asp:Label Id="lblJobTotal" runat="server" Text='<%# getJobTotalExcl(Eval("Id")) %>'>
</asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="JobStatus" HeaderText="Status" SortExpression="JobStatus"
FilterControlWidth="120px" HeaderStyle-Width="100px">
</telerik:GridBoundColumn>
<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="../../Files/Images/icons/icoWarranty.gif"
UniqueName="CalculateWarrantyButton" CommandName="CalculateWarrantyCommand" HeaderStyle-Width="30px">
</telerik:GridButtonColumn>
</Columns>
</MasterTableView>
<ClientSettings AllowDragToGroup="true">
<Selecting AllowRowSelect="True" UseClientSelectColumnOnly="True" />
<Scrolling AllowScroll="True" UseStaticHeaders="True"></Scrolling>
<Resizing AllowColumnResize="true" />
</ClientSettings>
<GroupingSettings ShowUnGroupButton="true" />
</telerik:RadGrid>
I'm new to radgrid and i have an issue with grid loading time is more than a minute event less number or none..
So, I have gone throught at db level every thing is fine and it is taking 1 second while data retrival at query level.
may it possiable with radGrid to slow down the process?
If so, let me know with optimization tips at grid level..
Code:
<telerik:RadGrid ShowGroupPanel="true" AutoGenerateColumns="false" ID="GrdJobList"
Skin="Vista" AllowFilteringByColumn="false" AllowSorting="True" ShowFooter="True"
runat="server" GridLines="None" AllowPaging="true" PageSize="10" OnSelectedIndexChanged="GrdJobList_SelectedIndexChanged">
<PagerStyle Mode="NextPrevNumericAndAdvanced" AlwaysVisible="true" />
<ExportSettings HideStructureColumns="True" FileName="ServiceSummaryJobs" ExportOnlyData="true"
IgnorePaging="true" OpenInNewWindow="true" />
<MasterTableView ShowGroupFooter="true" AllowMultiColumnSorting="true" GroupLoadMode="Server"
GroupsDefaultExpanded="true" Name="MainTable"
TableLayout="Fixed">
<Columns>
<telerik:GridTemplateColumn UniqueName="RadioButtonTemplateColumn" HeaderStyle-Width="30px">
<ItemTemplate>
<asp:RadioButton id="RadioButton1" OnCheckedChanged="RadioButton1_CheckedChanged"
AutoPostBack="True" runat="server">
</asp:RadioButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="../../Files/Images/icons/icoView.gif"
UniqueName="ViewButton" CommandName="ViewCommand" HeaderStyle-Width="30px">
</telerik:GridButtonColumn>
<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="../../Files/Images/icons/icoAuthorise.gif"
UniqueName="AuthoriseButton" CommandName="AuthoriseCommand" HeaderStyle-Width="25px">
</telerik:GridButtonColumn>
<telerik:GridBoundColumn DataField="Id" HeaderText="Id" HeaderStyle-Width="60px"
FilterControlWidth="20px">
</telerik:GridBoundColumn>
<%-- <telerik:GridHyperLinkColumn DataTextField="Id" HeaderText="Job Id" HeaderStyle-Width="60px" FilterControlWidth="20px" DataNavigateUrlFields="Id" DataNavigateUrlFormatString="javascript:openViewJobPopUp('{0}');" >
</telerik:GridHyperLinkColumn>
<telerik:GridTemplateColumn HeaderText="Job Id" HeaderStyle-Width="60px" FilterControlWidth="20px">
<ItemTemplate>
<dns:DotNetSmithPopBtn CommandName="popupViewJobCommand" ID="btnPopViewJob" BackColor="WhiteSmoke" ForeColor="blue" runat="server" Text='<%#Eval("Id")%>' PopupURL="~/Pages/Jobs/PopupQuickJobInfo.aspx" PopupURLParams='<%# "JobId="+Eval("Id").ToString()%>' Height="22px" Width="40px" />
</ItemTemplate>
</telerik:GridTemplateColumn> --%>
<telerik:GridDateTimeColumn DataField="ReceivedDate" HeaderText="Worked On" DataFormatString="{0:dd-MMM-yyyy}"
HeaderStyle-Width="70px">
</telerik:GridDateTimeColumn>
<%-- <telerik:GridBoundColumn DataField="ReceivedDate" HeaderText="Worked On" DataFormatString="{0:dd-MMM-yyyy}"
HeaderStyle-Width="130px">
</telerik:GridBoundColumn>--%>
<telerik:GridBoundColumn DataField="ContactName" HeaderText="Customer" SortExpression="ContactName"
HeaderStyle-Width="100px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PersonName" HeaderText="Requested By" HeaderStyle-Width="200px"
Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SiteName" HeaderText="Site" SortExpression="SiteName"
UniqueName="SiteName" HeaderStyle-Width="100px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="LocationDesc" HeaderText="Location" SortExpression="LocationDesc"
UniqueName="LocationDesc" HeaderStyle-Width="200px" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SerialNo" HeaderText="Serial No" SortExpression="SerialNo"
HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CustomerAssetNo" HeaderText="Asset No" SortExpression="CustomerAssetNo"
HeaderStyle-Width="90px" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EquipmentNo" HeaderText="Eqp No" SortExpression="EquipmentNo"
HeaderStyle-Width="70px" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ModelNo" HeaderText="Model No" SortExpression="ModelNo"
FilterControlWidth="60px" HeaderStyle-Width="70px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PurchaseOrderNo" HeaderText="Purchase Order"
FilterControlWidth="60px" SortExpression="PurchaseOrderNo" HeaderStyle-Width="70px">
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="Job Total (Ex-GST)" HeaderStyle-Width="70px">
<ItemTemplate>
<asp:Label Id="lblJobTotal" runat="server" Text='<%# getJobTotalExcl(Eval("Id")) %>'>
</asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="JobStatus" HeaderText="Status" SortExpression="JobStatus"
FilterControlWidth="120px" HeaderStyle-Width="100px">
</telerik:GridBoundColumn>
<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="../../Files/Images/icons/icoWarranty.gif"
UniqueName="CalculateWarrantyButton" CommandName="CalculateWarrantyCommand" HeaderStyle-Width="30px">
</telerik:GridButtonColumn>
</Columns>
</MasterTableView>
<ClientSettings AllowDragToGroup="true">
<Selecting AllowRowSelect="True" UseClientSelectColumnOnly="True" />
<Scrolling AllowScroll="True" UseStaticHeaders="True"></Scrolling>
<Resizing AllowColumnResize="true" />
</ClientSettings>
<GroupingSettings ShowUnGroupButton="true" />
</telerik:RadGrid>