Jump to content
Changes to the Jaspersoft community edition download ×

Help me to solve error

Felipe Fisichella

Recommended Posts

Hi, im new to jasperreports server, so  im trying the enterprise on trial but i also use the community version, where i only use it for reporting purpose. I connect the server to my data warehouse and data mart to make the reports but one report can consist 4 - 5 million data with 15 rows. What specifications do i need to use for this type of data ? Im using it on AWS server with 64gb RAM but still encounter slowness, like real slowness even after 30 minutes i didn't have any resullt downloaded.

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

Link to comment
Share on other sites

Hello There,  Troubleshooting a performance issue is a tedious task and it takes several iterations to find where the bottleneck lies. 

Here is where I start: Do you need to load all 4-5 million records into the report? Is anyone looking at that report?

Is the data optimized for reports? 

Where is the data? The db columns are indexed?

What type of report are you creating in Jaspersoft?

How long does it take to run the query and fetch the results on the DB server? That would be your benchmark to measure against the load time in Jaspersoft.

Also, What's the JVM allocation to the Jasperosft server on the Server?

Where is the database located? It could be a network bottleneck from DB to Jaspersoft Server and so on. I hope that gives some action items for you to further diagnose the problem


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...