File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jQuery Table plugins

 
Art Vandelay
Ranch Hand
Posts: 49
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15385
6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 49
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64205
83
IntelliJ IDE Java jQuery Mac Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Art Vandelay
Ranch Hand
Posts: 49
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic