• Post Reply Bookmark Topic Watch Topic
  • New Topic

Handling large data with dataTable Component  RSS feed

 
Ramaguru Ramasubbu
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I have a requirement to handle the large amount of data (may be be million records as a Result of one SQL Query) with JSF dataTable component.

But I thing, the dataTable component requires all my data to be in the memory in the form of some data Structure.

And I go 'out of memory' in tomcat when i try to access the second session.

Is there any solution other than increasing the JVM Memory size?

Thanks in advance
Ramaguru
 
Anoop V. Kumar
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you using some sort of datascroller?/ And in spite of that you run into memory issues??

Have you tried your database's pagination options - I know Oracle has one.

Anoop
 
Gerardo Tasistro
Ranch Hand
Posts: 362
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should use the LIMIT keyword in your SQL commands to limit the rows returned. No point in getting all the records if you will never display them all at one point in time. When the user scrolls in the data table just request your query again with a new LIMIT.

Are you using JDBC or some ORM like Hibernate?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!