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

RadFilter Performance

1 Answer 49 Views
This is a migrated thread and some comments may be shown as answers.
Top achievements
Rank 1
arnaud asked on 03 Oct 2012, 04:21 PM

Here is my code :

Protected Sub RadButton1_Click(sender As Object, e As System.EventArgs) Handles RadButton1.Click
           Dim sql = (From p In DbContext.VUE_BACKOFFICE_INTERFACE_PHOTOs Select p Where p.etablissement.Contains(RadTextBox1.Text) Or p.titre.Contains(RadTextBox1.Text) Or p.description.Contains(RadTextBox1.Text) Or p.copyright.Contains(RadTextBox1.Text) Or p.tag.Contains(RadTextBox1.Text) Or p.sous_collection.Contains(RadTextBox1.Text) Order By p.id_photo Descending)
        If sql.Count <> 0 Then
            RadFilter1.RootGroup.GroupOperation = RadFilterGroupOperation.Or
            For Each result In sql
                Dim expr1 As New RadFilterEqualToFilterExpression(Of Integer)("id_photo")
                expr1.Value = result.id_photo
        End If
    End Sub

Lets say that my query return 1500 records, 1500 lines/rows will be added to the RadFilter which cause the page to freeze and it goes nowhere.
Not only the page freeze but my whole website become unresponsive.

How would you deal with that ? How many rows can handle the Rafilter component (approximately).

Right now i'm doing a If sql.Count > 100 Then do nothing but I'd like to have your feedback on such a situation

Thank You

1 Answer, 1 is accepted

Sort by
Antonio Stoilkov
Telerik team
answered on 08 Oct 2012, 07:13 AM
Hello Arnaud,

I have created a video showing 1500 expressions added in RadFilter and the page renders within a second. Note that RadFilter performance depends on the user machine and other controls on the page. You could test how much your scenario could handle and set it on the appropriate value.

All the best,
Antonio Stoilkov
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Asked by
Top achievements
Rank 1
Answers by
Antonio Stoilkov
Telerik team
Share this question