jQuery Table plugins

Hi all,

I'm having a hard time choosing between the jqGrid and DataTables jQuery plugin. I want to use the plugin for displaying tables with large amounts of data, using features like pagination, column sorting and the like. So far both plugins qualify, but i'm also concerned with performance since i'll be displaying large amounts of data (approx. 100.000 rows). I googles around and searched this forum but was not able to find useful information about the performance of these two plugins. Do you guys have any experience with these two plugins and what can you say about the performance? Do you know of any other plugin that provides the above mentioned features and performs reasonably with large amounts of data?

100,000 rows on the client is not going to happen with any plug-in. Plus the browser will probably be slow as can be with that much data being loaded in a traditional table.

The table code would have to support serverside sorting and paging if you want to have decent performance.

Eric

Eric Pascarello wrote:100,000 rows on the client is not going to happen with any plug-in. Plus the browser will probably be slow as can be with that much data being loaded in a traditional table.

The table code would have to support serverside sorting and paging if you want to have decent performance.

Eric

Thanks for your response.

Any idea if there is a (jsp) component (taglib or something similar) that can provide or assist in accomplishing serverside sorting and paging?

That's best performed by the database itself. Each major SQL dialect has a way of asking for only a "slice" of the entire data set.

There's a JSP FAQ that covers this.

Bear Bibeault wrote:That's best performed by the database itself. Each major SQL dialect has a way of asking for only a "slice" of the entire data set.

There's a JSP FAQ that covers this.

Thanks.

http://faq.javaranch.com/java/PaginationOrPaging