• Post Reply Bookmark Topic Watch Topic
  • New Topic

2 lakh record from db to List object out of memory problem  RSS feed

 
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I have a situation to fetch 2 lakh record to java list object and iterate for some statistic calculation.
while doing i got out of memory problem so can any one please help me out to solve.

ASAP please.
 
Bartender
Posts: 11445
18
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
G.Sathish kumar wrote:
ASAP please.


http://faq.javaranch.com/java/EaseUp
http://faq.javaranch.com/java/PatienceIsAVirtue

Have you tried increasing the heap size? Is it possible to use the DB itself to do this calculation? If I am not mistaken, most of the DBs are geared towards handling high volume of data.
 
Marshal
Posts: 56608
172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How large is each record? 200,000 doesn't sound a lot of memory, if each record is &le 1 kB.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!