Skip to content

Improve profiling framework for DB transactions #39

@pierre

Description

@pierre

DAO and DAO_DETAILS only record ResultSet execution time, which is good for checking slow queries but this doesn't give us the full DB picture. In particular, it doesn't measure the impact of the following calls:

  • GET/SET TRANSACTION ISOLATION LEVEL
  • SET AUTOCOMMIT
  • EXECUTE STATEMENT
  • DEALLOCATE PREPARE STATEMENT
  • COMMIT

We don't have to go too low level (if needed, we can always enable the jdbc.audit logger), but it would be useful to at least measure the time taken to run full transactions.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions