Birt performance, xml dataset

gprigent

Hi,

i am new in Birt, and i need to speed up report previously done by another one.

I attached 2 files a xml file and the rptdesign file.

The report's generation with those files take over 8 minutes with birt 2.0.1 and over 3 minutes with birt 2.3.1.

But the xml file's size is only 50kb.

This time is too long for us.

Could someone take a look at my files attached and give me some hints to speed up the generation ?

Thank's

Glenn

mwilliams

Hi Glenn,

The reason it's taking that long for your report to run is because you have one dataSource being split into 38 dataSets. (I believe that's what I counted) What happens when you have that setup is that the xml file is opened and all the initialization happens each time to read the file and the entire thing is stepped through 38 times. So, it's more like you have a 1900kb file to step through, not counting 38 open and close times. There are a couple things you could do to make this faster. If possible, you could break the xml file up into 38 source files so that you only step through the data you need for each dataSet. However, you will still have 38 open and closes. The best would be if you could combine all of your dataSets into 1 dataSet that would step through your xml source only once with only 1 open and close.

Hope this helps.