Hi Fabio.

Not exactly true. Every time you query something form SqlServer there
is always shared read locks. The amount of locks does not really tell
anything. It all depends on what kind of locks there is and how long
they last.

Tapio


On Thu, May 14, 2009 at 10:32 PM, Fabio Maulo <[email protected]> wrote:
> NH?
> NH does not lock nothing implicit.
>
> 2009/5/14 adressin <[email protected]>
>>
>> Hi all... so I know this is a complicated question, but I just don't
>> know what to do at this point. I inherited a fairly large NHibernate
>> project that was suffering from serious performance issues. 2 years
>> later, I still cannot seem to figure out what is really causing the
>> bottleneck.
>>
>> I have fixed Session bloat issues, page size issues, Select N+1 issues
>> (there are still more of these, but not to the point that we would see
>> this kind of degradation... I don't think), large number of writes,
>> etc... many of the common pitfalls with using NHibernate. I have used
>> nhprof to find many issues and fix them... I have used a code profiler
>> to find erroneous code.
>>
>> After all that we still are getting slammed by our clients reporting
>> poor performance. Unfortunately, I feel we have reached the limits of
>> my teams expertise with figuring out what is going on.
>>
>> We recently got word from a clients IT DBA that he is noticing a
>> "ridiculous" amount of db locks... he states he is seeing upwards of
>> "2 million per second". We have not researched this much yet as we
>> just heard this, but can anyone translate that into how we could
>> approach that with respect to using NHibernate?
>>
>> Thank you in advance for any information,
>>  Aaron
>>
>
>
>
> --
> Fabio Maulo
>
> >
>



-- 
Tapio Kulmala

"Those are my principles, and if you don't like them... well, I have
others" - Groucho Marx

http://friendfeed.com/tapsakoo
http://twitter.com/tapiokulmala
http://www.linkedin.com/in/tapiokulmala

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to