Optimized web data grids - ASP .NET vs ASP .NET MVC and jQuery

I am developing a web application that will display data in grid form. I need to be able to load thousands of rows quickly. I also need to be able to sort data by multiple columns and filter columns by search string. I am currently using ASP .NET MVC and Infragistics jQuery iGrid.

At the moment I am loading 1000 records and have already started to hit some performance problems.

I was originally using pagination to make the inital load quicker, however this means I need to do my sorting/filtering server side otherwise it will only sort/filter the records on that page, and not on the entire datasource.

Alternatively I can load the entire datasource into the grid (which with 1000 records takes ~20 secs to bind) and then do all sorting/filtering client side which is pretty much instantaneous.

My colleague reckons we should scrap the jQuery controls and use the ASP .NET controls instead. They are more mature and have more functionality.

Is it worth taking my colleague's advice? Will the ASP .NET controls be faster than the jQue开发者_运维问答ry controls? Should I move to a straight ASP .NET project or would it be worth trying to incorporate the ASP .NET controls into an MVC project?

It's not a mature project but it's sure worth a look, so check out Telerik Kendo UI and grid widget, it's based on jQuery.

http://demos.kendoui.com/grid/index.html

I think It depends of your jQuery grid control (if it's using JSON for paging, I think there is no performance problems). I use two differents grids on two apps : - Telerik RadGrid with ASP.NET, mature, with lots of options and, with a good server side code, with good performance - My own jquery grid implementation with JSON and ASP.NET MVC on server side. Less more options but a better performance. You cannot have good perfs without pagination, that's the point.

The jQuery UI team will provide a new grid component in a few weeks I think. So it may be cool for you.

I guess your question is related to this post:

jQuery Grid Binding in ASP .NET MVC is so slow

Basically the rendering and databinding of the igGrid (Infragistics jQuery grid) has very small footprint and impact on performance. Moreover, if you enable row virtualization (column virtualization is also supported), it shoudln't matter if you have 100 records or 100 000 in terms of rendering speed.

If you still experience issues which are related to rendering, you can also have a look at the following whitepaper:

http://help.infragistics.com/Help/NetAdvantage/jQuery/2011.1/CLR4.0/html/igGrid_Performance_Guide.html

Let me know if this helps. And thanks for the feedback. Angel