Report Runtime Optimizaiton

Comments

1 comment

  • Official comment
    Avatar
    Franck Reyherme

    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.