-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Java Heap error with Hibernate of 1 million record of databa
PostPosted: Wed Nov 30, 2005 7:06 am 
Newbie

Joined: Wed Nov 30, 2005 6:57 am
Posts: 1
We are using Tomcat 5.5 and Hibernate with Java also we are using database postgres which contains more than 2 million records.

When we just simple wnts to display first coloum of a table which contain heavy data its goes out of memory.

We just new in HIbernate and dont know is hibernate is able to handle such a large databse.

If it can how we increse the performance of the program.


Top
 Profile  
 
 Post subject: Re: Java Heap error with Hibernate of 1 million record of da
PostPosted: Wed Nov 30, 2005 7:54 am 
Senior
Senior

Joined: Mon Aug 22, 2005 5:45 am
Posts: 146
rohitankushe wrote:
We are using Tomcat 5.5 and Hibernate with Java also we are using database postgres which contains more than 2 million records.

When we just simple wnts to display first coloum of a table which contain heavy data its goes out of memory.

We just new in HIbernate and dont know is hibernate is able to handle such a large databse.

If it can how we increse the performance of the program.


you can increase the performance of your program by assigning more heap space to java: add VM parameter -Xms=256m -Xmx=758m

_________________
Please don't forget to give credit, if my posting helped to solve your problem.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Nov 30, 2005 8:11 am 
Expert
Expert

Joined: Sat Jun 12, 2004 4:49 pm
Posts: 915
Quote:
you can increase the performance of your program by assigning more heap space to java: add VM parameter -Xms=256m -Xmx=758m


I don't sure that it help for 2 milion records - try use ScrollableResults and cursor query (last postgresql > 8.0 support cursor query) or hibernate setFirstResult/setMaxResults


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.