poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Geller ...@4js.com>
Subject Re: DO NOT REPLY [Bug 51160] [PATCH] Provide ability to produce very large xlsx files using the regular high level API with the default heap space of 64MB
Date Tue, 17 May 2011 13:14:32 GMT
Hi Yegor,

>// almost 10x slower than XSSF!
>There is something to work on. 

I ran the SSPerformaceTest and found the following values:
HSSF   default  10000x100  5 sec
SXSSF  default   10000x100  7sec   

I did not do the XSSF test because my VMWare doen't have that much heap
space. But never mind, the HSSF value is the same as in your test and the
SXSSF value is slightly above, which is 5 times faster then XSSF so that I
can't reproduce your 302 seconds. Did you use the original SSPerformanceTest
or a modified version? 

>Alex, would you like to continue working on this feature and submit more

Absolutely, but keep in mind that for the moment my Excel knowlege is
minimal. I will look into the two issues Boolean and Formulas and I am
confident to having that work as expected. Is there a unit test for the Cell
class? Besides of issues writing the XML, I suspect strongly that the
current implementation has a number of bugs in the getters/setters. As an
example consider setting a cell type to string and then setting a numeric
formua (Formulas are typed in Excel, no?). Is that an error or should the
type change to numeric then? My feeling is, that it would be more productive
if you took care of that part of the code. I think that I can manage to get
the XML right without too much trouble. What do you think? 

View this message in context: http://apache-poi.1045710.n5.nabble.com/DO-NOT-REPLY-Bug-51160-New-PATCH-Provide-ability-to-produce-very-large-xlsx-files-using-the-regular-B-tp4375895p4403468.html
Sent from the POI - Dev mailing list archive at Nabble.com.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message