Jump to content
Changes to the Jaspersoft community edition download ×

Jaspersofts suitability for reporting against large datasets


Recommended Posts

I'm currently experiencing issues with reporting against large sets of data using Jaspersoft.

We've designed a reporting tool that enable users to run a set of prebuilt reports, or buidl their own reports once given access to a pre-defined template.

When we try and build a report (dragging fields from a template into a report designer - ) we're finding that the performance is very poor.

My development team are advising that the "adhoc designer" is the problem and that it is poorly designed and struggles to handle large data volumes.

The process of building a report as I understand it involves "full queries being run returning the maximum number of records each time" which causes the process of building a report to be very slow.

Is this a known problem, has anyone else struggled with something similar, and how did you resolve the problem?

Any advice?


Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

This is a known problem. Unless the data are cached, Adhoc Designer performance slows down. However, as the name suggests, it's a "design" tool. Try saving it as adhoc "report". JasperReports Server caches data so the second time the report is viewed, it should be faster than the first time.


Link to comment
Share on other sites

Thanks Hozawa. Could you possibly expand on "try saving it as adhoc report"? Are you suggesting that the way we've exposed the information to be reported against could be changed for our end users? Please accept my apologies if that isn't a valid interpretation.  My background isn't one that is technical. I'm trying to work out the best way to get a performant product.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...