We are in a similar situation - having just upgraded from 2.1 to 5.1.

Sravan, I'd love to hear whether the change Roman suggested - of an 
AdoNetTransactionFactory 
- worked for you in terms of performance ?

Miles


On Friday, 29 June 2018 12:20:12 UTC+12, Sravan Kumar wrote:
>
>
> 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>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nhusers+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/nhusers/ade6bdb4-ab67-458b-8f3c-82703053216c%40googlegroups.com.

Reply via email to