Hi, until today I assumed that the Xslt transformation engine (used in imports notably) was reasonably fast.
Unfortunately, it's not : I needed to do an import of a 330 MB XML file with a XSLT transform, and it took at least five hours to just do the transformation, then the import was reasonably quick.
So I tried to pre-transform the XML with the Saxon command line utitility and it took 14 seconds !
14 seconds vs hours !
So there needs to be a rewrite for this XSLT transformation
Of course, as there's another thread calling for Xpath 2 support, The XML/XSLT rewrite is Long overdue, but I wanted to make sure that speed would be taken care of in that rewrite. I'll have to treat 1 GB XML files routinely, and I'm also afraid to hit the 2 GB file size limit soon, that limit should also be alleviated.