> Hello, I'm getting a little frustrated with FOP performance. > We are generating an XML on the fly that contains a few tables with > about 1,000 rows in total. > We passdown this XML along with XSL to the transformer to generate PDF > from our servlet. > (transformer.transform( inXML, new SAXResult( > driver.getContentHandler())); ) > It works well, but it works slow. > It takes about 5 minutes for 1,000 rows and this is only for transformer > translation (excluing any data query time or jdom XML building time) > I read through past emails/FAQs and I think I tried them all and it > still does not improve the performance... > > Please help!! > > Here is what I have done. > > 1) run with more memory - yes I tried with 512MB (I don't get > OutOfMemory error) > 2) run in separate VM - only helps other requests coming to the site > 3) try with the latest FOP - I did - mine is fop-0.20.4 > 4) try with the latest xalan.jar and xerces.jar - tried them, but no > improvement > 5) cache XSL style sheet - didn't really help... > 6) use multiple page-sequence - got it to work and I don't get > OutOfMemeory exception, but still performance didn't get better. > (even if I break them into multiple page-sequences, I will still > have to read through one row at a time, right? - that's why performance is > not really improving..) > > 7) no forward-reference - I don't have any page numbers > 8) try with new JDK - trying with JDK 1.3 > 9) seralize servlet request - haven't done this, but I doubt this will > have any performance impact (I'm testing with one request for now) > 10) no images - I don't have any... > 11) Don't make the XML tree too deep - mine is very flat with 2 levels > deep. > > I have 1,000 rows and each row looks something like following in XML > > <ROW> > <TA_FUND_CODE>539</TA_FUND_CODE> > <LONG_NAME>Some Fund</LONG_NAME> > <DAILY_FACTOR>0.00003760000</DAILY_FACTOR> > <SHORT_RATE_365>NA</SHORT_RATE_365> > <LONG_RATE_365>NA</LONG_RATE_365> > <RATE_360>NA</RATE_360> > <CURR_7_DAY_YIELD>NA</CURR_7_DAY_YIELD> > <SEVEN_DAY_EFF_YIELD>1.400000000</SEVEN_DAY_EFF_YIELD> > <AVG_30_DAY_RATE>1.580000000</AVG_30_DAY_RATE> > <PRICE>1.0000</PRICE> > <RATE_DATE>09 Dec 2002</RATE_DATE> > <CURRENCY>USD</CURRENCY> > <STATUS>I</STATUS> > </ROW> > > > Here is the question: > Is this normal to take this long - 5 minutes - to produce a few tables > with combined total 1,000 rows (about 30 pages)? > > Any other better way? > > Thank you for your suggestions. > > Regards, > IL
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
