RadFilter Performance

2 posts, 0 answers
  1. arnaud
    arnaud avatar
    105 posts
    Member since:
    Jul 2008

    Posted 03 Oct 2012 Link to this post


    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
  2. Antonio Stoilkov
    Antonio Stoilkov avatar
    530 posts

    Posted 08 Oct 2012 Link to this post

    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.
Back to Top