jphayes Posted June 18, 2020 Share Posted June 18, 2020 Linux operating system, JasperReport Server 7.5, Jaspersoft Studio Professional, Postgres SQL server, couple of users running queries for QA purposes but nothing overly large.I have a query that generates about 15 rows of data in about 1 second. When I apply this to a Report using Studio and run the entire report renders in about 4 seconds on one page. There are no additional variables or complex formulas just a straight row by row presentation of the data.When I upload this report and run it on the Server I get a runtime of 5 sec (rare) to 90+ sec which is where my gateway cuts it off and generates a 502 Error page. Seems to fall more into the higher time ranges to run.Can anyone tell me why this would be running slow on the Server Report Viewer (ie. log in, go to the repository and click on the report to run) or advise me on how to proceed to find/fix the issue?I have sat with my SecOps person and we did not find any high running CPU or filesystem space issues. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now