I did the profiling of application, when using Transactions vs when not using transactions. when using transactions seems like AutoFlushIfRequired is called
several times, which seems to be culprit. Is there is any change in NH 5.x onwards in the way flush is performed. we didn't change flush settings when migrated to NH 5.0 from 3.3 <https://lh3.googleusercontent.com/-Ijx__2CsIU8/Wzq3E_JeWmI/AAAAAAAACrQ/3TUtthQinIocKXkoBacXjTa45YKBB78CACLcBGAs/s1600/Tx_Issues.jpg> On Saturday, June 30, 2018 at 2:55:22 AM UTC-7, Frédéric Delaporte wrote: > > This is not a known trouble. Moreover the rework only concerned > transaction scopes, not ITransaction. I have no clue about what happens in > your case. > > Le vendredi 29 juin 2018 18:16:26 UTC+2, sravan a écrit : >> >> 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> >> Enter code here... >> >> >> -- --- You received this message because you are subscribed to the Google Groups "nhibernate-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to nhibernate-development+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
