Multiple joined data sets very slow

Hello,
I'm new to BIRT so please forgive me if I am missing something obvious. I need to create a report that requires multiple joined tables (data sets). Joining two data sets together is fine, but when I start adding more joins (joins of joined data sets) it gets very very slow to return results. (I need a total of 8 data sets joined together)

As a note, I've previously joined the same 8 tables using Actuate report designer and had no problems. The results from a data preview is almost instantaneous using Actuate.

The problem is my company is moving away from Actuate and adopting BIRT as the reporting solution.

Does the order in which data sets are joined make a difference? Any ideas on how to speed up data queries using multiple joined data sets using BIRT is greatly appreciated.
Thank you.

Find more posts tagged with

Comments

mwilliams

If using SQL queries, is it not possible to do your joins in your query? Using BIRT to do the joins will definitely be much slower. Any joining you can do within your query would be advantageous!

When talking about previewing in Actuate, are you talking about with the viewer? Or are you talking about the preview tab or preview results within the dataSet editor itself?

rbguy

Michael, Thanks for the quick reply. You are correct, when I bring over the SQL query that was generated from the Actuate report and use that with BIRT instead of joining data sets like I previously did, it works great. The data preview is very quick.

As for your question about previewing in Actuate, I was referring to the preview data button and also when I view the data in the report.

Thanks again for your help with this!
Roger

mwilliams

You're very welcome! Very glad to help. Welcome to the community! Let us know whenever you have questions!