Jaspersoft report really slow

3 posts / 0 new
Last post
nike_shikari
nike_shikari's picture
Offline
Last seen: 3 months 2 weeks ago
Joined: Mar 2 2012
Junior Boarder

Posts: 14

Nikhil S
Jaspersoft report really slow

I am using jaspersoft server community edition and regular mysql driver to run reports.
I can execute the underlying sql query directly against the infinidb server and it runs in 1.5 seconds. But when i run the jasperreport from iReport or from jasperserver, it takes forever.

If i check[i] show processlist [/i]when the report is running, it shows me the query in the state "copying to tmp table".

Any thoughts on whats going on ? Is the mysql driver messing it up ? Is there a infinidb specific driver which i can use ?

Infinidb is very promising and we want to use to under our reports. But right now this is a stumbling block.

radams
radams's picture
Offline
Last seen: 21 hours 53 min ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Re: Jaspersoft report really slow

Hi,

We use the MySQL front end for InfiniDB. As long as the cleint is set up to run with MySQL it should work. We do have a document that describes how to set up JasperSoft on our Enterprise Software site.

http://www.calpont.com/resources/resource-library/category/9-infinidb-en...

Thanks,

Robert
Calpont

nike_shikari
nike_shikari's picture
Offline
Last seen: 3 months 2 weeks ago
Joined: Mar 2 2012
Junior Boarder

Posts: 14

Nikhil S
Re: Jaspersoft report really slow

Yes, i can get my iReport working. But its too slow. I dont face the same issue when using Pentaho reports against infinidb.

Seems like jaspersoft does something funny when running report against infinidb.