Newbie Question - Report Performance in JasperServer

[Matthew Scullion]

Hi all,

 

Firstly - apologies for what is probably a dumb newbie question.  I am just getting into BI and JasperSoft.

Setup details:

- MYSQL

- Jaspersoft Enterprise (demo edition) installed on 2 core, 8gb Windows 2008 Server

I have created a simple Datawarehouse in MYSQL which contains several tables: a fact table of sales information (sales reference number, value, date etc) and also have some dimension tables for sales representative, product and customer.

The sales fact table has about 40,000 records in it.   The customer table a few thousand.  The other dimensions tables just a few hundred each.

I have created a Domain which points to by MYSQL DWH and in that Domain setup iner joins from the sales fact table to the customer dimension (based on 'Customer ID'), the item dimension (based on 'Item ID') and the Sales Representative dimension (based on 'sales rep ID').

I've then gone into JasperServer, created a new adhoc report and started dragging on the fields I want in my report.  Most work fine but when I come to add two fields in particualar (which happen to be Product group major and Product group minor, both on the product dimension table), the report is EXTREMLY slow to update - I am talking like 10 or 15 minutes.  All the other fields are pretty much instant.  When I look on the server, processor utilisation is up at 40-50% whilst it's running.  Note, this is in 'Design' mode, I haven't actually "Run" the report yet [as the design is taking so long with this performance issue].

What am I doing wrong?

Many thanks indeed for any help.

Regards,

Sculli