poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack <somerandomlo...@gmail.com>
Subject Re: SSPerformanceTest: Is the FAQ still accurate?
Date Sun, 10 Apr 2016 15:59:22 GMT
I'm having the exact same issue, I've tracked down this message from 
StackOverflow.
I've tested read performance on two XLS and XLSX with identical content 
(around 75000 rows, 25 columns).
HSSF takes under 5 sec; XSSF takes 15-20 sec.

Any idea what is the issue with XSSF performance?


On 15.02.2016 17:00, Drew Spencer wrote:
> Mike DeHaan <mike <at> mikeandzoya.com> writes:
>
>> As a followup, a user has replied to my stack overflow post with some
>> information that might be helpful in tracking this issue down. Here is
> the
>> link to his post:
>>
>> http://stackoverflow.com/a/34266795/4471563
>>
>> I ran the same tests in my environments and came up with similar
> numbers.
>> -Mike DeHaan
>>
> I have also asked the same question. Would love to get an answer to this
> either way. My similar post on StackOverflow is here:
> http://stackoverflow.com/questions/34995058/apache-poi-much-quicker-
> using-hssf-than-xssf-what-next
>
> I received an good answer with the link to the streaming reader, but
> unfortunately I don't think I can use it because my code runs on app
> engine.
>
> Thanks to anyone that can help.
>
> Drew Spencer
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>


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


Mime
View raw message