Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » BIRT report with XML datasource: performance problem
BIRT report with XML datasource: performance problem [message #158122] Thu, 04 May 2006 08:35 Go to next message
Eclipse UserFriend
Originally posted by: marc.leineweber.icc-gmbh.de

Hello,

there once was a similar question to this group but nobody gave a hint to a
solution, so I try it again. Does anybody use XML datasource without
performance problems, and if yes can provide an example report? I started
with BIRT 2.0.1, but the problem is still present in 2.1rc2.

I have a report basing on an XML datasource and three datasets defined for
the source, my report contains two subreports. I have no big amount of data
rows (2 in the main dataset with 1 and 1 resp. 6 and 7 in the datasets for
the subreport), but it takes 12 seconds to run and render the report. It
seems to me that the XML file is parsed multiple times, so the question is:
is there a cache to activate or do I have to use a special XML structure to
avoid the performance problem?

Thank you in advance, regards

Marc
Re: BIRT report with XML datasource: performance problem [message #158658 is a reply to message #158122] Fri, 05 May 2006 10:13 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jason.c.mail.emis.com.tw

We have the same problem too. So I try to use script data source and
parsing the xml with jdom. The result is amazing(30s -> 2s).
Re: BIRT report with XML datasource: performance problem [message #158679 is a reply to message #158658] Fri, 05 May 2006 11:37 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: marc.leineweber.icc-gmbh.de

Hello Jason,

thank you for your answer. Actually I already thougt that scripted data
source could be an alternative, but I was afraid that it might be too
complicated. But your result sounds promising, so I probably should give it
a try.

Do you think it's possible for you to send your report and data source as an
example to me?

Thank you again, regards,

Marc

"JasonChen" <jason.c@mail.emis.com.tw> schrieb im Newsbeitrag
news:41e1826574abb52817860e47351909a5$1@www.eclipse.org...
> We have the same problem too. So I try to use script data source and
> parsing the xml with jdom. The result is amazing(30s -> 2s).
Re: BIRT report with XML datasource: performance problem [message #158772 is a reply to message #158679] Fri, 05 May 2006 15:45 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jason.c.mail.emis.com.tw

Hi, Marc
Can you give me your xml sample data. I'll use your data to make a sample
report for you.

Jason
Re: BIRT report with XML datasource: performance problem [message #159255 is a reply to message #158122] Tue, 09 May 2006 06:05 Go to previous messageGo to next message
Gary Xue is currently offline Gary XueFriend
Messages: 193
Registered: July 2009
Senior Member
Marc, can you please file a Bugzilla bug and attach the XML data and report
design that's giving you the performance problem? BIRT engineers can then
investigate.

thanks,

--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer
"Marc Leineweber" <marc.leineweber@icc-gmbh.de> wrote in message
news:e3cec9$djb$1@utils.eclipse.org...
> Hello,
>
> there once was a similar question to this group but nobody gave a hint to
a
> solution, so I try it again. Does anybody use XML datasource without
> performance problems, and if yes can provide an example report? I started
> with BIRT 2.0.1, but the problem is still present in 2.1rc2.
>
> I have a report basing on an XML datasource and three datasets defined for
> the source, my report contains two subreports. I have no big amount of
data
> rows (2 in the main dataset with 1 and 1 resp. 6 and 7 in the datasets for
> the subreport), but it takes 12 seconds to run and render the report. It
> seems to me that the XML file is parsed multiple times, so the question
is:
> is there a cache to activate or do I have to use a special XML structure
to
> avoid the performance problem?
>
> Thank you in advance, regards
>
> Marc
>
>
Re: BIRT report with XML datasource: performance problem [message #159577 is a reply to message #159255] Tue, 09 May 2006 12:11 Go to previous message
Eclipse UserFriend
Originally posted by: marc.leineweber.icc-gmbh.de

Hello Gary,

I created a new bugzilla bug (#140773) for the problem. I will try to
workaround using scripted data source, but I would rather use the XML file
as data source directly.

Regards,

Marc

"Gary Xue" <gxue@actuate.com> schrieb im Newsbeitrag
news:e3pbc8$mjj$1@utils.eclipse.org...
> Marc, can you please file a Bugzilla bug and attach the XML data and
> report
> design that's giving you the performance problem? BIRT engineers can then
> investigate.
>
> thanks,
>
> --
> Gary Xue
> Actuate Corporation - Product Development
> BIRT Committer
> "Marc Leineweber" <marc.leineweber@icc-gmbh.de> wrote in message
> news:e3cec9$djb$1@utils.eclipse.org...
>> Hello,
>>
>> there once was a similar question to this group but nobody gave a hint to
> a
>> solution, so I try it again. Does anybody use XML datasource without
>> performance problems, and if yes can provide an example report? I started
>> with BIRT 2.0.1, but the problem is still present in 2.1rc2.
>>
>> I have a report basing on an XML datasource and three datasets defined
>> for
>> the source, my report contains two subreports. I have no big amount of
> data
>> rows (2 in the main dataset with 1 and 1 resp. 6 and 7 in the datasets
>> for
>> the subreport), but it takes 12 seconds to run and render the report. It
>> seems to me that the XML file is parsed multiple times, so the question
> is:
>> is there a cache to activate or do I have to use a special XML structure
> to
>> avoid the performance problem?
>>
>> Thank you in advance, regards
>>
>> Marc
>>
>>
>
>
Previous Topic:Test execution Report - In BIRT
Next Topic:java.lang.AssertionError running pdf format, why??
Goto Forum:
  


Current Time: Sun Jul 21 15:20:24 GMT 2024

Powered by FUDForum. Page generated in 0.03956 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top