Oracle Stored Procedure Query type Dataset loads huge metadata [message #1733241] |
Wed, 25 May 2016 16:23 |
Viktor Kalman Messages: 3 Registered: May 2016 |
Junior Member |
|
|
Hello!
I'm new in BIRT.
I have some similar BIRT report, which has two Dataset, a Master and a Detatail. Both Dataset are Oracle stored procedure type. The Master table contains groups, and the Detail table is embedded into the Master rows and also in the group lines too.
In execution at every row of Master query, BIRT calls Metadata from database engine asking what the Detail Dataset stored procedure looks like. querying metatdata needs ten times, a hundred times more than the real query. The report runs for over 15 minutes in case of a few hundred Master row, but the number of rows can be up to thousands or more.
Is there any way to improve the performance?
For example, this metadata control can be turned off that don't deal with the stored procedure.
Or other idea?
I use BIRT 4.5, Oracle DB 11g and run on Apache Tomcat/8.0.24
Thanks a lot!
Viktor
|
|
|
Powered by
FUDForum. Page generated in 0.26952 seconds