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

Filter with 3100 rows extremely slow

18 Answers 239 Views

TreeListView

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

This question is locked. New answers and comments are not allowed.

Jeffrey Schultz asked on 24 Jan 2011, 09:52 PM

When you click the filter icon and select criteria, the filter process takes about a minute; is there any way to speed this up since sort operations take a couple of seconds? When the process is completed, even though the criteria I specified exists within the sample set, the RadTreeListView doesn't display any rows. Am I doing something wrong? I can see exactly what I am searching for at the top of the list before I click the filter icon.

<UserControl.Resources>

<DataTemplate x:Name="DragCueEquipmentTemplate">

<telerik:RadDockPanel Margin="2" MaxWidth="200">

<TextBlock Text="{Binding ID}" FontWeight="Bold" telerik:RadDockPanel.Dock="Top" />

<TextBlock Text="{Binding Name}" Foreground="Green"

telerik:RadDockPanel.Dock="Left" />

</telerik:RadDockPanel>

</DataTemplate>

</UserControl.Resources>

<Grid x:Name="LayoutRoot" Background="White" DataContext="EquipmentListViewModel">

<telerik:RadTreeListView x:Name="EquipmentsTreeListView"

AutoGenerateColumns="False" IsDragDropEnabled="True"

IsReadOnly="True" dragDrop:RadDragAndDropManager.AllowDrag="True"

IsDragTooltipEnabled="True" IsDropPreviewLineEnabled="True"

DataLoadMode="Asynchronous" EnableRowVirtualization="True"

ItemsSource="{Binding EquipmentItems}">

<telerik:RadTreeListView.ChildTableDefinitions>

<telerik:TreeListViewTableDefinition x:Name="def" ItemsSource="{Binding Children}" />

</telerik:RadTreeListView.ChildTableDefinitions>

<telerik:RadTreeListView.Columns>

<telerik:GridViewDataColumn DataMemberBinding="{Binding equip_item.lin_id}" Header="ID" Width="100" ShowDistinctFilters="False"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding Name}" Header="Name" Width="*" ShowDistinctFilters="False"/>

</telerik:RadTreeListView.Columns>

</telerik:RadTreeListView>

<controls:BusyIndicator HorizontalAlignment="Center" VerticalAlignment="Center"

x:Name="busyIndicator" IsBusy="False" BusyContent="Loading equipment list, please wait..." Grid.Row="0">

</controls:BusyIndicator>

</Grid>

18 Answers, 1 is accepted

answered on 15 Mar 2011, 10:05 AM

Hello Vlad,

Scenario is the same I uploaded yesterday with the support ticket "Low Performance in Expand All Groups" for the GridViewControl. If you remember the demo application, I have a TileView control inside a RadWindow with four TileViewItems. Each TileViewItem contains a GridView loaded with an items catalog. Well, in fact, in my real scenario, one of this catalogs has a hierichical structure and it's loaded in a TreeListView. I've tried to add a TextBox at top of each GridView/TreeListView to allow user searching items in the catalogs. Via a custom behavior I'm able to add a filter descriptor to the GridView/RadTreeListView each time user enters text on the searcher TextBox. I'm quite sure the issue is related with expanding hierarchy or groups as TreeListView expand all hierarchy each time filter is updated. I've tried to perform filtering for my self, that's updating ItemsSource property with a new collection containing only the items that match the filter criteria and it works fine except if I call ExpandAllHierarchyItems method, then it takes long time to update the UI.

As I've seen, with new 2011 Q1 release, expanding groups/hierarchy is much faster as control is not trying to expand all item but only those that are potentially visible.