Birt report datasets sequential or parallel execution?

abhiallen

Hello,

I am currently working on the report optimization for some of our business reports and it seem they have multiple datasets with complex sql taking 3-4 secs exec time. I tried combining 3 queries into 1 sql which is taking 6 secs to execute. is this a good optimization technique of combining datasets or any other better technique i am unaware of?

Also BIRT report datasets execute sequentially or in parallel?

If datasets are executed sequentially then 3 datasets with 4sec exec time SQL would take total 12 secs to execute all 3 datasets, but if datasets execute in parallel then these 3 datasets shouldn't take more than 4-5 secs for all.

thanks
Abhishek

kclark

3-4 seconds for execution time seems pretty good to me, and if you can put them together for a 6 second execution seems great. It really depends on how much data is in the DB though.