Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

Why is RT/Trans so much higher than Exec Total?



We've recently switch platforms for our application. I've now noticed in the Database dashlet that RT/Trans is noticeably higher (sometimes 30%+) than Exec Total. From the definition of RT/Trans acquisition time, query prep, and query execution time is part of this number. Since RT/Trans is higher than Exec Total then this implies that RT/Trans is showing app server side time while Exec Total is showing only the database server execution time. If that's true then does this imply that my application is spending a lot of time getting connections and preparing the SQL? I'm concerned that we're not implementing the TomEE connection pool properly.

Thank you in advance for any insights you can provide.

Sandy Leung.