nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Performance issue with XML input file

shweta.chalwadi

Hi,
We have a requirement to design a BIRT report using XML file as input.
The design requirement is such that we have to create 9 data sets and join these to create a final data set holding details for complete set (total 5 joined data sets).
 
Report design is using "List" element with grouping on certain field (using final joined data set). There are two repeatable sections added with "Table" (using 2 data sets from 9 normal ones).
 
Now, this report is taking more than 30 mins to process 1000 records.
 
Based on various discussions, I have also tried to use scripted data sets, however even those need to parse XML multiple times and taking approx. 26 mins to process same set of 1000 records.
 
Attaching sample data and report design files. 
 
Kindly please suggest if there are any alternate to improve performance?
 
 
Thanks,

Find more posts tagged with

Comments

mwilliams

Do you have access to change the format of your XML? Would wrapping each set of customer info into a <customer></customer> tag help at all? I'm assuming that normally the xml shows different customers not a cut and paste of the same info?

shweta.chalwadi

Hello Mike,
Thanks for your response.
To certain extent, we have control to customize XML file. I have tried to wrap records as per suggestion, however no performance improvement as we still need to parse XML with multiple XPath values.
 
As of today I have tried to remove some un-necessary looping through script (while fetching records); which saved approx. 6 more mins.
 
Please let me know if you find any other possibilities here?
 
 
Thanks,
Shweta Chalwadi.

mwilliams

I meant for ease of use with the standard ODA. I think that would help get rid of your joint data sets, which would make that report faster than the scripted data set report. Just a guess.

shweta.chalwadi

ohh ok ... let me try out if XML format can be modified ... 
Thanks!

shweta.chalwadi

Hi,
I have tried XML format change to print 1000 records in approx. 18 mins; however when i tried to verify for 5000 records it was not able to generate PDF in 3 hrs. Looks like a big time scalability issue here. 
 
Any suggestions on improving this aspect?
 
 
Thanks,
Shweta Chalwadi