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
-~----------~----~----~----~------~----~------~--~---
