Announcement Announcement Module
Collapse
No announcement yet.
Registering Spring transaction synchronization slow? Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Registering Spring transaction synchronization slow?

    Hi,

    I'm trying to remove bottlenecks in our Spring 3.1 application. Currently our request takes 80 ms and I'm trying to bring it down to 60 ms as per customer's requirements:/

    I noticed that the Spring Transaction Synchronization part takes up about 9ms. What is this action doing and why would it be taking that long? I have a SQL server Database Connection as well as a proprietary database which isn't involved in this transaction.

    Also, is there anyway of not setting the READ_ONLY flag and isolation flag before returning to the pool, this is consuming unnecessary cycles. For me it should be set when retrieved from the the DataSource.

    Code:
    2013-02-26 20:12:09,914 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Audit log written successfully.
    2013-02-26 20:12:09,915 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Returning cached instance of singleton bean 'txManager'
    2013-02-26 20:12:09,915 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Returning cached instance of singleton bean 'pamsTransactionManager'
    2013-02-26 20:12:09,916 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Returning cached instance of singleton bean 'ppfeTransactionManager'
    2013-02-26 20:12:09,916 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Participating in existing transaction
    2013-02-26 20:12:09,916 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Opening Hibernate Session
    2013-02-26 20:12:09,917 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Registering Spring transaction synchronization for new Hibernate Session
    2013-02-26 20:12:09,926 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Audit log written.
    2013-02-26 20:12:09,927 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Initiating transaction commit
    2013-02-26 20:12:09,927 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Committing JDBC transaction on Connection [jdbc:mysql://pams-za-qa-db/PAMS, UserName
    =pamsdev@PAMS-ZA-QA, MySQL-AB JDBC Driver]
    2013-02-26 20:12:09,927 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Closing Hibernate Session
    2013-02-26 20:12:09,928 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Resetting isolation level of JDBC Connection [jdbc:mysql://pams-za-qa-db/PAMS, UserN
    ame=pamsdev@PAMS-ZA-QA, MySQL-AB JDBC Driver] to 4
    2013-02-26 20:12:09,929 DEBUG TRX_ID:[158320508476097] PARAM:[27829809006] Resetting read-only flag of JDBC Connection [jdbc:mysql://pams-za-qa-db/PAMS, UserNa
Working...
X