Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
285
WebData Grid is very slow while loading Huge data
posted

Hi,

we have a customized webdatagrid with 20 columns per row and have around 1200 rows to display. its taking around 45 seconds to load the entire data and display it to user. Since this grid is on the Homepage of the site. the home page loading is also very slow. we are using Webdatagrid V12.2

<asp:Panel ID="Panel" runat="server">
<ig:WebDataGrid ID="UltraWebGrid" runat="server" OnInitializeRow="UltraWebGrid_InitializeRow"
EnableRelativeLayout="false" HeaderCaptionCssClass="GridHeaderCaption" OnInit="UltraWebGrid_Init"
OnRowUpdated="UltraWebGrid_RowUpdated" OnRowUpdating="UltraWebGrid_RowUpdating"
OnColumnMoved="UltraWebGrid_ColumnMoved" EnableAjax="true" EnableAjaxViewState="true"
EnableDataViewState="True" OnColumnResized="UltraWebGrid_ColumnResized" OnColumnSorted="UltraWebGrid_ColumnSorted"
>
<Behaviors>
<ig:Sorting>
</ig:Sorting>
<ig:ColumnMoving EnableInheritance="True">
</ig:ColumnMoving>
<ig:Filtering FilterType="ExcelStyleFilter">
</ig:Filtering>
<ig:ColumnResizing Enabled="true">
<ColumnSettings>
<ig:ColumnResizeSetting EnableResize="true" />
</ColumnSettings>
</ig:ColumnResizing>
<ig:EditingCore AutoCRUD="false">
<EditingClientEvents CellValueChanged="UltraWebGrid_Editing_CellValueChanged" />
<Behaviors>
<ig:CellEditing>
<CellEditingClientEvents />
<EditModeActions EnableOnActive="True" MouseClick="Single" />
</ig:CellEditing>
</Behaviors>
</ig:EditingCore>
</Behaviors>
</ig:WebDataGrid>
</asp:Panel>

Any Idea on how to speed this up? can we use Asyncscroll/Paging or any other property of the grid to initially load few records and then get some more in background asynchronously and improve the speed of the Page/application?

Thanks,