[Solved] Data taking an extremely long time to load

[Scott]

Greetings!

I'm using a RadGridView that's bound to a QueryableCollectionView. I'm using this in more than a dozen pages without a problem.

I have one page where the loading time is 60+ seconds for only 1800 rows of data, and I'm hoping somebody can spot something I missed:

<df:DataForm x:Name="dfSubassembly"
                         Width="{Binding Width, ElementName=GV1}"
                         CurrentItem="{Binding SelectedSubassembly}"
                         ItemsSource="{Binding Subassemblies}"
                         AutoEdit="False"
                         AutoCommit="False"
                         Height="0"
                         Margin="0,0,0,10">
</df:DataForm>
<telerik:RadGridView x:Name="GV1"
                                     ItemsSource="{Binding Subassemblies}"
                                     DataLoadMode="Asynchronous"
                                     ShowGroupPanel="False"
                                     EnableColumnVirtualization="True"
                                     EnableRowVirtualization="True"
                                     SelectedItem="{Binding SelectedSubassembly, Mode=TwoWay}"
                                     AutoGenerateColumns="False"
                                     HorizontalAlignment="Left"
                                     IsReadOnly="True">
                    <i:Interaction.Triggers>
                        <i:EventTrigger EventName="SelectedCellsChanged">
                            <ei:GoToStateAction StateName="Open"/>
                        </i:EventTrigger>
                    </i:Interaction.Triggers>
                    <telerik:RadGridView.Columns>
                        <telerik:GridViewDataColumn DataMemberBinding="{Binding SubassemblyCode}" Header="Subassembly Code" />
                        <telerik:GridViewDataColumn DataMemberBinding="{Binding SubassemblyDescription}" Header="Subassembly Description" />
                        <telerik:GridViewDataColumn DataMemberBinding="{Binding UsageCode}" Header="Usage Code" />
                        <telerik:GridViewDataColumn DataMemberBinding="{Binding UsageCodeDescription}" Header="Usage Code Description" />
                        <telerik:GridViewDataColumn DataMemberBinding="{Binding DrawingFile}" Header="Drawing File" />
                        <telerik:GridViewDataColumn DataMemberBinding="{Binding FercAccount}" Header="FERC Account" />
                        <telerik:GridViewDataColumn DataMemberBinding="{Binding MaintenanceAccount}" Header="Maintenance Account"/>
                    </telerik:RadGridView.Columns>
                </telerik:RadGridView>
<telerik:RadDataPager x:Name="radDataPager" Grid.Row="1" Source="{Binding Subassemblies}" PageSize="10"/>

      
The callback fxn for my Web Service:

private void GetSubassembliesCallback(ObservableCollection<TSMVVM.Model.Subassemblies> subassemblies)
{
    if (subassemblies != null)
    {
        if (subassemblies.Count > 0)
    {
            Subassemblies = new QueryableCollectionView(subassemblies);
        }
    }
}

 The line where I set my Subassemblies = new QueryableCollectionView(subassemblies) takes about 60 seconds. subassemblies is just my OC<Subassemblies> with a count of 1846.

SS

[Vlad]

Hello,

 Your grid is measured with infinity height most probably. This may happen if any virtual items control (like ListBox, DataGrid, RadGridView, etc.) is inside StackPanel, ScrollViewer, Canvas, etc. - in this case there will be no rows virtualization and the component will try to create all rows at once.

Best wishes,
Vlad
the Telerik team

[Scott]

Yeah I caught that late last night too. Setting a fixed height on the grid (inside of a stackpanel) fixed it. Thanks Vlad.