Data table with large number of rows

[martind1111]

I have implemented a data table using the rich:dataTable component and am also using the rich:dataScroller to only present portion of the table when the number of records doesn't fit in a single page. This table potentially has a very large number of rows. To avoid loading the whole table in memory, the code that backs this table uses CachedRowSetImpl and the ResultSetDataModel. However, I get a Java heap space error when I try to display the table and the number of rows gets in the hundreds of thousands, so I suspect that, even though I use a CachedRowSetImpl and I limit the number of rows to display per page to 20, the whole table is still loaded in memory. I am wondering if someone has written an implementation that is memory efficient (only loads the records that are shown to the user) and uses a scroller and would want to share their code in this forum (or point me out to some link that describes a solution for this problem).

I also am wondering if it is a good idea to use CachedRowSetImpl because I get some warning during compile that states that this class is proprietary to Sun and may not be available in the future.

Thanks,

Martin

[alibsd]

Take a look at this:
http://livedemo.exadel.com/richfaces-demo/richfaces/dataTable.jsf?tab=dataModel&cid=215642

This will probably solve your problem.

Regards

[martind1111]

"alibsd" wrote:
Take a look at this:
http://livedemo.exadel.com/richfaces-demo/richfaces/dataTable.jsf?tab=dataModel&cid=215642

This will probably solve your problem.

Regards

I like the example, altough it is not complete. The AuctionDataProvider class is not viewable and this is where the JDBC calls of interest would be listed.

[martind1111]

"martind1111" wrote:

"alibsd" wrote:
Take a look at this:
http://livedemo.exadel.com/richfaces-demo/richfaces/dataTable.jsf?tab=dataModel&cid=215642

This will probably solve your problem.

Regards

I like the example, altough it is not complete. The AuctionDataProvider class is not viewable and this is where the JDBC calls of interest would be listed.

Haven't found the exact reference on RichFaces Web site to AuctionDataProvider source code, but this link points to an older version, which should allow someone to implement a data model that implements paging:

http://www.java2s.com/Open-Source/Java-Document/JBoss/richfaces-ui-3.1.4.GA/org/richfaces/demo/extendeddatamodel/AuctionDataProvider.java.htm

[supernovasoftware.com]

Have a look at this excellent article.

http://www.jsfcentral.com/articles/speed_up_your_jsf_app_1.html

[nbelaevski]

"martind1111" wrote:

"alibsd" wrote:
Take a look at this:
http://livedemo.exadel.com/richfaces-demo/richfaces/dataTable.jsf?tab=dataModel&cid=215642

This will probably solve your problem.

Regards

I like the example, altough it is not complete. The AuctionDataProvider class is not viewable and this is where the JDBC calls of interest would be listed.

You can get the sources here: http://anonsvn.jboss.org/repos/richfaces/trunk/samples/richfaces-demo