Report Runtime Optimizaiton

Follow

Robert Gold

August 28, 2019 15:35

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?

1

• Official comment

  

  Franck Reyherme August 29, 2019 00:41

  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 Permalink

Please sign in to leave a comment.