Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Best performance question(Which is the best solution?)
Best performance question [message #915916] Tue, 18 September 2012 04:03 Go to next message
Blaine Mising name is currently offline Blaine Mising name
Messages: 25
Registered: December 2010
Junior Member
I've a report that shows all our products between 2 dates (date start, date end)

The report shows all the products in a table. The table shows a product by row. In each row there is other table that shows the product added date, product deleted date and other table that contais the list of all the modifications dates of the product.

Not all the produts must have delete date.

All the information is in a unique table.

The product have an id, then all information of an ID is the same product.
The table contains a column that specifies if the register is inserted(I), updated (U) or deleted (D)

My report actually shows a parameter window asking 2 values:
1. Start Date
2. End Date

It uses 3 Data set:
1. A select to get the insertion date of a product ID.
2. A select to get the product delete date of a product ID (same id as data set 1 and 2)
3. A select to get the updated date of the same product id that data set 1


The problem is that the product table has millions of registers, and the report generation is very slow because the 3 data sets are sql under other sql's. I can't modify table structure.

Is this the best solution? If not, how can I improve the report performance without modifying table?

It's possible for example obtain all data between dates in a unique SQL (a data set) and do conditions with birt to show in each row the needed information?




[Updated on: Tue, 18 September 2012 04:05]

Report message to a moderator

Re: Best performance question [message #916021 is a reply to message #915916] Tue, 18 September 2012 08:15 Go to previous message
Tomas Greif is currently offline Tomas Greif
Messages: 53
Registered: September 2010
Member
Hi,

I've tried, but it is quite difficult to understand your question :/ I guess your problem can be solved with some row groups.

Can you please post (at least):

- structure of the database table (field names, data types) and sample data
- screenshot of expected output

Tomas
Previous Topic:Problems building BIRT 3.7.1 from instructions
Next Topic:PHP dumps JSON file for BIRT to read from
Goto Forum:
  


Current Time: Sat Jul 26 09:18:20 EDT 2014

Powered by FUDForum. Page generated in 0.01480 seconds