Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Birt report datasets sequential or parallel execution?
Migrateduser
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
Find more posts tagged with
Comments
There are no comments yet