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
Complex MySQL Statement in BIRT
Migrateduser
<p>Hi all together,</p><p> </p><p>we're using Birt as a Tool for prividing several reports in our company. We have have a ticket-system named JIRA, from where we get the data for the reports.</p><p> </p><p>In these reports we also will show the booked times and we ne to aggregate that time over many tickets.</p><p>We use the database from this ticketsystem to get the needed information. As a result we have a veeeery complex SQL Statement over 200lines with many subqueries and joins.</p><p>In out test instance the reports worked with a bad performance (20s and longer to load a report). In out productive instance it doesn't work, because there is too much data in it an the Statement gets a timeout after more than 10minutes.</p><p> </p><p>We thought about usind temporary tables to splitt the whole statements in little fragements that are more performant, but I've read in other forums, that temporary tables are not supportet in BIRT.</p><p> </p><p>Does somebody of here now, how we can handle this Problem?</p><p>I do really need your help.</p><p> </p><p> </p>
Find more posts tagged with
Comments
There are no comments yet