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

RadGrid Lodaing time issue

0 Answers 67 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Chakrapani
Top achievements
Rank 1
Chakrapani asked on 18 Apr 2012, 02:01 PM
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>

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Chakrapani
Top achievements
Rank 1
Share this question
or