performance issue using xml datasources

jdelgoulet

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 !