Hi! I've seen that Fabio and Ayende a long time ago said that Transactions are mandatory, even if only querying. They quoted the Hibernate reference also.
I've seen all this, as I wasn't aware of this practise, so I decided to apply it. But when I did that, I found it's taking a lot of time to open a transaction (I have the DB in USA, and my app in dev environment is running here, in Argentina, so it has a little round trip time to call a begin transaction). A request to a page from my site, without transactions, is lasting 400ms, where as with transaction, it lasts 800ms. Only a simple Get is inside de transaction, and one lazy property being called in the view (that is also inside the transaction). So I started thinking, is this truly a good practise? What am I doing wrong by using a transaction in this case? Should I return to using transactions only when modifying entities? What are the problems I've got if I don't use a transaction when only reading? Thanks for anyone who can answer this! Leonardo
