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?
