aspose file tools*
The moose likes HTML, CSS and JavaScript and the fly likes jQuery Table plugins Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » HTML, CSS and JavaScript
Bookmark "jQuery Table plugins" Watch "jQuery Table plugins" New topic
Author

jQuery Table plugins

Art Vandelay
Ranch Hand

Joined: Dec 27, 2009
Posts: 49
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?
Eric Pascarello
author
Rancher

Joined: Nov 08, 2001
Posts: 15376
    
    6
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
Art Vandelay
Ranch Hand

Joined: Dec 27, 2009
Posts: 49
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?
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61766
    
  67

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.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Art Vandelay
Ranch Hand

Joined: Dec 27, 2009
Posts: 49
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jQuery Table plugins