If you could produce a sample demonstrating your problem I could take a
look when I got some time.
Currently in jxls SVN in jxls-examples module there is a simple StressTest
which just outputs a list of employees with forEach tag.
It has only 6 columns in the template but 30000 records are rendered in 6
seconds (tested on Win-7, jdk 1.6, Core i5 2.1Hz processor).
--
Regards,
Leo
On Wed, Aug 1, 2012 at 10:17 PM, Pathak, Hiren (GE, Corporate, consultant) <
hiren.pat...@ge.com> wrote:
> Hello, I have a simple jxls template that has one foreach loop and 16
> columns, but it is taking > 10 secs to render ~700 rows. ****
>
> ** **
>
> *Business Sign Off*
>
> *Corporate Sign Off*
>
> *Home Office LEID*
>
> *Entity Details*
>
> *BSLA Code*
>
> *Branch Tax Generator*
>
> *Country*
>
> *Per DCS RAF Basket Categories*
>
> *DCS Source Flag*
>
> *(a) Per DCS Branch Taxes*
>
> *(b) Per TLC Tax Return*
>
> *(b)-(a) QAR Adjustment*
>
> *QAR Basket Categories*
>
> *Comments*
>
> <jx:forEach items="${qarData}" var="qarItem">****
>
> ${qarItem.busSignOffUser} ${qarItem.busSignOff}****
>
> ${qarItem.corpSignOffUser} ${qarItem.corpSignOff}****
>
> ${qarItem.hoLeId}****
>
> ${qarItem.entityDetails}****
>
> ${qarItem.bslaCode}****
>
> ${qarItem.btgLeId}****
>
> ${qarItem.countryDesc}****
>
> ${qarItem.rafBasketCategory}****
>
> ${qarItem.sourceFlag}****
>
> ${qarItem.dcsBranchTax}****
>
> ${qarItem.tlcBranchTaxEval}****
>
> ${ qarItem.qarAdjEval }****
>
> ${qarItem.qarBasketCategory}****
>
> ${qarItem.comments}****
>
> </jx:forEach>****
>
> ** **
>
> ** **
>
> Any thoughts? I’ve removed all if statements from the template and moved
> them to the bean, which improved the performance from > 40 secs. ****
>
> But 10 secs is still problematic as I need to add additional sheets. ****
>
> ** **
>
> Any help is appreciated. ****
>
> ** **
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> jXLS-user mailing list
> jXLS-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jxls-user
>
>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
