XSLT Processing

[xmlwiz]

Hi

Any idea if its going to be faster to do transformation from a structured dataset from one format to another using XSLT or some sort of Java code which reads the data from the DB and creats the new format.
Example: RosettaNet 1.2 3A4 to cXML

Usually, XSLT transformation is very resource intensive and takes time... wondering doing it through DB and Java code makes it faster? I will appreciate if any one has done this already

 

[scotth4v]

I've found that it is much faster to do it with Java than with XSL. I was using extensive XSL comparisons to link 2 datasets as the data was displayed, and once I got to around 3000 DB entries, it would crawl and even time out. I started doing it with the servlet and it is blazingly fast now. I was trying to keep as much as possible in the XSL template so that it could be easily maintained, but it got to be just too slow.

I'm sure my code wasn't the most efficient, but I'd say do as much as possible with SQL/Java.

-Scott