Telerik blogs

Grid client-side data-binding performance with 1 mil. records

by Vladimir Enchev
November 05, 2008 Web 0 Comments


Just before our Q3 release I've made quick test to see how the grid will perform with 1 mil. records table and here is the result:

Untitled

In this example the grid is bound with our new client-side declarative approach to a static page method:

...

<DataBinding Location="~/Default.aspx" SelectMethod="GetData" SortParameterType="Linq"  FilterParameterType="Linq" />  

...

...

[System.Web.Services.WebMethod]   
public static Telerik.Web.UI.GridBindingData GetData(int startRowIndex, int maximumRows, string sortExpression, string filterExpression)   
{   
    return RadGrid.GetBindingData("DataClassesDataContext", "MyTables", startRowIndex, maximumRows, sortExpression, filterExpression);   
} 

...

and I've used our OnDataBinding/OnDataBound client-side events to measured the grid binding performance:

<script type="text/javascript">   
    var start = null;   
    function RadGrid1_DataBinding(sender, args) {   
        start = new Date();   
    }   
 
    function RadGrid1_DataBound(sender, args) {   
        $get("div1").innerHTML = String.format("Time to retrieve and bind data: <span style='color:red;font-weight:bold;'>{0}</span> ms", new Date() - start);   
    }   
</script>  

 

[Live | Download | Database]

About the Author

Vladimir Enchev

is Director of Engineering, Native Mobile UI & Frameworks

Comments

Comments are disabled in preview mode.