XML Publisher report performance
I've recently moved a report that was created using a concurrent request SQLPlus program. It executed the report and formatted all in the SQL, this report ran and finished almost instantly.
After moving the report to BI Publisher - the report generated looks infinitely better than the old SQL report, but it is at a very large performance hit.
After updating the RTF template to just a blank word document, so there is no formatting of the XML data into PDF, the performance stayed relatively the same. Therefore, I'm investigating the data definition template for possible ways to make this more streamlined, limiting the length of groups/element names, avoiding redundancy, using efficient grouping, etc. I was wondering though if there exists best practices documentation for creating data definition templates?