performance issue using xml datasources
Options
hi,
I'm trying to improve performance in my report but it seems that i'm stucked on what Birt can do.
Let me explain the situation.
I using an xml data source and created 4 datasets : A / B / C / D
Dataset A contains about 50 records. The others, 150 each.
Now datasets B, C and D have a column call "id" that "references" the id column of dataset A.
(Sort of foreign key/primary key).
the problem is : I want to display in 3 different tables the list of B, C and D records for each A record.
To do so I'm using a List bind to the dataset A and 3 tables in this list bind to dataset B / C and D with the following filter parameter : row["id"] equalTo outer.row[id]
The problem is that Birt takes about 20 minutes to generate the report on a core 2 duo 2.16Ghz.
I was wondering if it exists a better solution to resolve my performance issue - ( I saw the "parameter" in sql dataset but it is not available to xml dataset ...).
Thanks a lot !
I'm trying to improve performance in my report but it seems that i'm stucked on what Birt can do.
Let me explain the situation.
I using an xml data source and created 4 datasets : A / B / C / D
Dataset A contains about 50 records. The others, 150 each.
Now datasets B, C and D have a column call "id" that "references" the id column of dataset A.
(Sort of foreign key/primary key).
the problem is : I want to display in 3 different tables the list of B, C and D records for each A record.
To do so I'm using a List bind to the dataset A and 3 tables in this list bind to dataset B / C and D with the following filter parameter : row["id"] equalTo outer.row[id]
The problem is that Birt takes about 20 minutes to generate the report on a core 2 duo 2.16Ghz.
I was wondering if it exists a better solution to resolve my performance issue - ( I saw the "parameter" in sql dataset but it is not available to xml dataset ...).
Thanks a lot !
0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 102 General Questions
- 123 Services
- 40 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 901 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 127 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax