[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Performance problem on Oracle
At 10:38 25/01/01 -0800, you wrote:
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. Thank you for this offer, but it is simply so huge I cannot give you everything (the DTD files only are near 50). However, I can give you the main XSL stylesheet, so you can have a look, but it won't run by itself. If you want, I can give you a "necessary package", but I don't want to bother you. Actually, it takes near 5 seconds, and as we are using it in a local environment, redirecting it directly to a web server, it looks like infinity. 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. I chased most of them. However, one of my problems is that I need such construct to isolate an element. Does thing like : /*/firstlevel//myelt are better than //myelt ? (the * is here since I have several DTDs, so different root elements) 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. It is perfectly true that I execute it in Oracle 8i. In command line, it seems faster, which is unatural to me, as in our java code, the DTD as well as the XSL stylesheet are "pre-parsed" in DOM objects. 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?
(DEBUT means beginning) It seems the parsing take some time. Perhaps the java code would help you ? Thanks in any case for your attention. ______________________________________________________________ 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/ -- Paul TERRAY - Ingénieur Systèmes Documentaires 4Dconcept Centre d'affaires - 22, rue Etienne de Jouy 78353 Jouy en Josas CEDEX Tel. 01 34 58 70 70 - Fax. 01 39 46 06 90 email : terray@xxxxxxxxxxxx XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|