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