[nhusers] Migrating to NH 5.1 from NH 3.3, drastic reduction in performance when using Transactions

[Sravan Kumar]

Recently Upgraded our mission critical application to use NH 5.1 from NH
3.3. NH 5.1 performance is comparable to NH 3.3 when not using transactions
but
it drops down dramatically when using Transactions. The degradation is
happening either using NHibernate ITransaction or Transaction scopes.
Seems like whole Transaction handling has been revisited from NH 5.0. Is
there is any setting that needs to be turned on to bring the performance
back to normal.

Here is the session factory configuration


<entry key="hibernate.connection.connection_string" value="XXXXX"/>
<entry key="hibernate.connection.provider" value=
"NHibernate.Connection.DriverConnectionProvider"/>
<entry key="dialect" value="NHibernate.Dialect.MsSql2012Dialect"/>
<entry key="connection.driver_class" value=
"NHibernate.Driver.SqlClientDriver"/>
<entry key="current_session_context_class" value="wcf_operation" />
<entry key="show_sql" value="true"></entry>
<entry key="command_timeout" value="12000"></entry>
<entry key="track_session_id" value="false"></entry>

[Roman]

<entry key="transaction.factory_class" value="
NHibernate.Transaction.AdoNetTransactionFactory"/>