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.