Java Heap error with Hibernate of 1 million record of databa

rohitankushe · **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.

axismundi · **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

snpesnpe · **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