Has anybody had issues with C# ASP.NET projects using nhibernate taking forever to load after a rebuild? The issue we are having occurs on our live web server, and whenever we make updates to the binaries, and have to update, it takes 2-3 minutes minimum before the server is responsive again. It seems to be an issue with the startup setup that nhibernate goes through in creating SQL server connections, or something along those lines. the config file is as follows:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.0" >
<session-factory name="nhibernator">
<!-- properties -->
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="connection.connection_string">Server=localhost;initial catalog=Mobux;user id=sa;password=sa</property>
<property name="show_sql">false</property>
<property name="dialect">NHibernate.Dialect.MsSql2000Dialect</property>
<property name="use_outer_join">true</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<!-- mapping files -->
<mapping assembly="Test" />
</session-factory>
</hibernate-configuration>

which seems pretty normal, any ideas?

try

<property name="use_reflection_optimizer" value="false" />

this will boost the startup performance dramtically

Regards
Klaus

will this have any performance affects on the rest of the site, now that the reflection optimizer is turned off..? it wont cause the rest of the site to slow down?

You are correct in thinking that turning off the reflection optimizer will have performance implications.

Can you use the 1.2Alpha version instead? It's reflection optmizier can use leightweight code generation (LCG) and the startup time is next to nothing.