poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Vladimirov <vlser...@gmail.com>
Subject Re: taking too long to create xlsm
Date Wed, 22 Jun 2011 10:35:29 GMT
Hi,

1) Try to extract the part around "wb.write(fileOut);" to another
method, so profiler can show if exactly write() method is perfomance
bottlecheck.

2) Personally i think the biggest problem is a lot of calls to
shiftRow() operation. Can profiler show the time spent for this method
execution? If it's the case, then try to replace deleting rows with
coping "good" rows to new sheet and replacing old one with new.

Best regards,
Sergey.

On Wed, Jun 22, 2011 at 1:55 PM, dpront <gerard.agda@xmarter.com> wrote:
> Hi,
>
>  I have already used the poi-3.8 but it still yield the same result.
>
>  This is the profiling result of my code:
>
> http://s760.photobucket.com/albums/xx242/gerardagda/?action=view&current=Profileresult.jpg
>
>  And here is my latest code so far:
>  http://privatepaste.com/2167f7bc2c
>
> Thanks.
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/taking-too-long-to-create-xlsm-tp4497635p4513516.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>



-- 
Sergey Vladimirov

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


Mime
View raw message