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.