Hi,

I dont know if any of you guys is experiencing this situation.:
Whenever I try to debug a project using nhibernate, the dataaccess
layer becomes really slow. Any use of HQL to access data becomes
almost impossible.

When I switch to binary mode, it does not happen.

Does anyone know how to fix this, or even improve the debug performance experience?



Thanks a lot in advance,


Joao,

Can you try to debug a project accessing a database without NHibernate?

Anyway, add traces to your code to see where your CPU is used (and how much time)

What type of database are you using? SQL Server? Does your project have SQL debugging enabled? If so, try disabling that option for a speed improvement. How are you referencing NHibernate? Using the compiled assemblies as downloaded? Or are you compiling NHibernate as part of your project?

I am using SqlServer as a Database, Sql debugging is disabled. I am using Nhibernate as a binary lib.

You got the point, didnt you? The cpu is used by nhibernate. I see that it delays 100 milliseconds between records. I dont know exactly where.

Do you have log4net configured?
When I was running without log4net Hibernate didn't slow the debugging at all.
Debugging became VERY slow once I've added log4net.

yep that was the problem. Log4net was slowing down everything.

thanks a lot