Performance comparison between jQuery Datatable and jQGrid?

Question

We implemented the jQuery datatable for 3000 to 4000 rows of data along with 50 columns. But it degrades the performance as we implemented the different functionalities of datatable like column level search, global search, mrender, pagination etc.

We are using jQuery v1.7.2 and jQuery dataTable 1.10.7 js. How to improve the performance of jQuery datatable or any other alternatives to jQuery datatable to display such a huge data?

One of my friend suggested to use jQGrid.

What is the performance comparison between jQuery datatable and jQGrid? Which is better? or any alternative to improve performance?

Answer 1

I have been using jgGrid in production for quite a while now. I had an option too between selecting datatables and jqGrid. I have tested both. Datatables performance deteriorates with increasing record size.

For using jqgrid, loadonce: true should not give a problem as @Oleg mentioned in the comments up to 10,000 records.

I have tested jqGrid in production for over 2 million records and its working just fine. It is noteworthy that I implemented server side paging here and used json as the return datatype.

I have implemented tons of extra features like filter toolbar(This implements search globally), Inline Editing, Server side as well as client side pagination, and tons of other features which jqGrid supports.

Moreover its really easy to extend jqGrid functionalities and add your custom functions as per your requirements.

As an added bonus, you can get lots of help with already asked questions (or ask your own) on StackOverflow for jqgrid.