Have you tried recent nhprof bit? Ayende has integrated this duration reporting into NH Core
http://ayende.com/Blog/archive/2009/06/28/nh-prof-query-duration.aspx Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Wed, Jul 1, 2009 at 11:01 PM, Jan Limpens <jan.limp...@gmail.com> wrote: > Hello, > > first of all - my doubt stems from the usage of nhprof and it's Duration > feature. I am not sure how much I can trust it, due to it's beta stage. > > When profiling my application, depending on their complexity the queries > shown in the profiler all have a duration from ~130ms to ~460ms, which is an > awful lot. If I run the very same queries in MSSQL Query Analyzer, I get a > spectrum between 1 and 30ms, which is much better of course. > > What could be causing this? > > My config is like that: > > <facility id="atm" > > type="Castle.Facilities.AutomaticTransactionManagement.TransactionFacility, > Castle.Facilities.AutomaticTransactionManagement" /> > <facility id="nhibernate.facility" > isWeb="true" > > type="Castle.Facilities.NHibernateIntegration.NHibernateFacility, > Castle.Facilities.NHibernateIntegration" > > configurationBuilder="Fex.Data.FluentNHibernateConfigurationBuilder, > Fex.Data"> > <factory id="nhibernate.domain.factory" > alias="nh.facility.default"> > <settings> > <item key="show_sql">false</item> > <item key="max_fetch_depth">1</item> > <item > key="dialect">NHibernate.Dialect.MsSql2005Dialect</item> > <item > key="connection.provider">NHibernate.Connection.DriverConnectionProvider</item> > <item > key="connection.driver_class">NHibernate.Driver.SqlClientDriver</item> > <item key="connection.connection_string">Data > Source=.\SQLEXPRESS;Initial Catalog=Fex;Integrated Security=True</item> > <item key="connection.isolation">ReadCommitted</item> > <item key="default_schema">Fex.dbo</item> > <item key="query.substitutions">true 1, false 0, yes > 'Y', no 'N'</item> > <item key="adonet.batch_size">10</item> > <item > key="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory, > NHibernate.ByteCode.Castle</item> > <item key="use_reflection_optimizer">true</item> > </settings> > </factory> > > I load the mappings during app_start within code. > > So either NhProf is wrong, or something else... I just have the feeling > that the app is slower than it ought to be. So this just might be the cause. > Anyone could help me a bit here? > -- > Jan > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---