Hi Nick, Thanks for answer.
Its not practical to add 4GB just to handle POI alone. My current application is a standalone server with maximum heap space of 2GB, so far for office-2003 it is working fine, however just for office 2007 POI support I cannot demand extra hardware. We have to find a working solution which will fit my memory requirement ( and for this matter I hope for most of the users ) !! If this is limitation in POI, please document it on your website, so user can think about their own requirement before migrating or using it other then discovering at very later stage like UAT. We will also follow the strategy what Yogor has recommended for Excel writing and will keep posted. Regards, Jaydeep. Nick Burch wrote: > > On Fri, 31 Jul 2009, jayrp11 wrote: >> We are in process of migrating from HSSF to SS model. We have already >> converted our code base to SS model and while testing encountered with >> strange issue. Memory requirement is very high in SS model also same >> degrades performance while processing 2007 excel file > > This has been discussed several times before, please take a look at the > list archives for details. Short summary - xml processing takes more > memory than OLE2 processing, and the xml wrapper layer we use takes more > memory again, but makes development much faster. Given that we still > haven't quite finished 3.5, quicker development is an important feature! > > If high memory use is a really big issue for you, then it's certainly > possible that you could sponsor someone to work on reducing the memory > footprint. Personally, I compared my daily programming rate with the cost > of putting another 4gb of memory into all my servers, and would've barely > been able to justify the cost of firing POI up in a profiler and poking > around, let alone trying to fix anything... > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://www.nabble.com/POI-%3A-Memory-and-Perfomance-tp24756016p24791154.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
