Is there a performance penalty in executing read only queries under transaction?

It depends on what underlying transaction manager you are using. The default spring "transaction per thread, no XA transactions" probably doesn't have a any penalty. If you are using JBoss with the XA transaction manager, then it will write some data to a transaction log .

Theoretically there's a performance penality to adding AOP (and thus introspection/reflection) overhead to more methods than necessary. Also there's the added overhead of opening and closing more transactions than needed. It should be up to the developer coding the data-acces layer to know when and if a transaction should be started IMHO.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions