BIRT report with XML datasource: performance problem [message #158122] |
Thu, 04 May 2006 08:35 ![Go to next message Go to next message](theme/Solstice/images/down.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
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 #158679 is a reply to message #158658] |
Fri, 05 May 2006 11:37 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) ![Go to next message Go to next message](theme/Solstice/images/down.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
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 #159255 is a reply to message #158122] |
Tue, 09 May 2006 06:05 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) ![Go to next message Go to next message](theme/Solstice/images/down.png) |
Gary Xue![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=xxue%40opentext.com) 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 Go to previous message](theme/Solstice/images/up.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
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
>>
>>
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.02524 seconds