Subject: Re: [xsl] Performance problem on Oracle|
From: Paul Terray <terray@xxxxxxxxxxxx>
Date: Fri, 26 Jan 2001 19:59:32 +0000
Please send me your XML output and XSLT stylesheet testcase so I can make sure it's not something pathological in your stylesheet that is making our XSLT processor slower than you'd like.
I find many user's reports of slow stylesheets occur on large documents because they accidentally use patterns like "//foo" when they mean ".//foo" and other little "gotchas" whose performance implications are amplified on large document sizes.
Please include in your email whether you're trying to run this on the Java VM *inside* the database or outside, and if outside, please indicate platform and JVM your running since performance varies widely by JVM implementation as Mike Kay and others have reported here before.
Probably a dumb question, but are you counting only the transform time, or also the time it takes to produce the XML from the query?
Here is a log from the java execution (in ms) : DEBUT getHtmlFromXml DEBUT connection base ...: 4 DEBUT connection base OK: 6 XML File obtained...: 18 XML File parsed...: 2452 Before XSLT transform...: 2478 After XSLT transform...: 3711
______________________________________________________________ Steve Muench, Lead XML Evangelist & Consulting Product Manager BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG Author "Building Oracle XML Applications", O'Reilly http://www.oreilly.com/catalog/orxmlapp/