Report Runtime Optimizaiton
From a front end perspective, is it faster to setup any calculations in SQL and then pass the final values to the Jaspersoft Report server or is it just as fast to pass the initial values of columns and then do the calculations within Jaspersoft?
-
Official comment
Hi Robert,
Great question! Generally speaking, you will get faster runtime if you do calculations and logic statements in Jasper vs. doing them in SQL. This is not always true, so to some extent, the answer is "it depends." That said, the majority of the time, the report will run faster if you do as much work as possible in Jasper and keep the data returned by the SQL query as raw as possible.
I hope that helps!
Comment actions
Please sign in to leave a comment.
Comments
1 comment