Out Of Memory - String Operation

[Viks]

Hi,
   
  My app is running out of app.
   
  Code does a lot of string opeartion.It involves fetching records from DB
   
  Initially i was using string objects- Program used to finish in about 40-45 
min with ~95 cpu usage 
   
  We did some optimization on the code like changing the query from String to 
StringBuffer.
   
  This has improved the execution time and cpu usage.
   
  For 60k records the prog ran fine ....execution time improved from 30 mins to 
around 4 min and cpu usage from 95 % to 15%.
   
  For around 100k records my apps goes down on memory.
   
  Wondering if the app is able to sustain on String Obj why it is going down 
with StringBuffer Objects.
   
   


Viks
                                
---------------------------------
 Here’s a new way to find what you're looking for - Yahoo! Answers