Nhibernate.impl.SessionImpl.DoLoad() takes lot of time

Hi ,

In my project i am using Nhibernate to connect to Postgres database . I use YOURKIT profiler to analyze CPU time consumed by my project.

Suppose for doing one operation my projects take 41 minute then out of 41 min 35 min are taken by DoLoad() and DoLoadByClass() function .

This is very weird .

Internally in the call stack it calls :-

NpgsqlConnector.Open() Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector) Npgsql.NpgsqlState.ProcessBackendResponses(NpgsqlConnector) System.Net.Sockets.Socket.Poll(Int32, SelectMode)

Here Socket.Poll takes much of the time.

I want to know what are the most probable reason why DoLoad and DoLoadByClass is taking much of the time . ?

Thanks for your help .