Hi, 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. I have created small program with will generate Excel in both format (2003, and 2007). Below is out come from this program.
Running with 2003: (Used memory is printed at every 1000 row except last one) ------------------- Used memory : 1 MB Used memory : 5 MB Used memory : 5 MB Used memory : 7 MB Used memory : 10 MB Used memory : 12 MB Used memory : 15 MB Used memory : 17 MB Used memory : 20 MB Used memory : 22 MB Used memory : 24 MB Used memory : 27 MB Used memory : 29 MB Used memory : 32 MB Used memory : 34 MB Used memory : 35 MB POISSModelTest took : [3625] ms. for generating test.xls [Sheets:1, Rows:15000, Cols:10] Running with 2007: (Used memory is printed at every 1000 row except last one) ------------------- Used memory : 1 MB Used memory : 49 MB Used memory : 103 MB Used memory : 148 MB Used memory : 201 MB Used memory : 240 MB Used memory : 302 MB Used memory : 340 MB Used memory : 398 MB Used memory : 438 MB Used memory : 491 MB Used memory : 549 MB Used memory : 573 MB Used memory : 630 MB Used memory : 689 MB Used memory : 747 MB POISSModelTest took : [23125] ms. for generating test.xlsx [Sheets:1, Rows:15000, Cols:10] Source for POISSModelTest is attached. We would like to know is this an expected behavior(increase in memory footprint and response time). Please suggest if there is an way to improve the same. Thanks, Jaydeep. http://www.nabble.com/file/p24756016/POISSModelTest.java POISSModelTest.java -- View this message in context: http://www.nabble.com/POI-%3A-Memory-and-Perfomance-tp24756016p24756016.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]
