Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()

On Thu, Oct 15, 2009 at 10:02 AM, keshav upadhyaya
<ukeshav2009@gmail.com> wrote:
> Hi ,
>
> In my project I use Nhibernate to connect to Postgres.
> Currently it is very slow.
>
> I have used Yourkit profiller to get some key informaitons.
> In CPU profilling i have analyzed following  things : -
> Let me explain one by one : -
>
> 1- NHibernate.Impl.SessionImpl.DoLoad(Type, Object, Object, LockMode,
> Boolean)
>
> Takes lots of time .
>
> 2- Internally it calls thse function i am listing the last stack
>
> NpgsqlConnector.Open()
> Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector)
> Npgsql.NpgsqlState.ProcessBackendResponses(NpgsqlConnector)
> [Wall Time]  System.Net.Sockets.Socket.Poll(Int32, SelectMode)
>
> Finally in last the socket.poll takes most of the time .
>
>
> I want to know the probably causes of the socket.poll() consumes allot of
> time .
>
> Please help me out to know the places why in DoLoad,DoLoadByClass and
> Socket.Poll is taking lot of time .
>
> What are the scenario in which it might be getting slow down , Which i need
> to look .

I'm not sure that you're going to get too much help with this one on
this mailing list.  It's not really a PostgreSQL question.  You might
try the npgsql guys...

...Robert