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

Thanks Matthew for your quick reply .
Let me make my self more clear.

Suppose While doing one operation in my project, total time taken is 41
min .

in this 41 min around 35 min is takne by this call --

NHibernate.Impl.SessionImpl.DoLoad(Type, Object, Object, LockMode, Boolean)
and DoLoadbyClass().

And i believe internally these calls used
System.Net.Sockets.Socket.Poll(Int32, SelectMode)

Which take most of the time not a bit* time .

And when i Use *MSSQL *no such kind of polling happens and it work in aound
2-3 mins .

So i believe Nhibernate config filles or some other configuration w.r.t.
Postgres is not proper or improvement required.

Thanks,
keshav

On Thu, Oct 15, 2009 at 7:39 PM, Matthew Wakeling <mnw21(at)cam(dot)ac(dot)uk> wrote:

> On Thu, 15 Oct 2009, keshav upadhyaya wrote:
>
>> [Wall Time] System.Net.Sockets.Socket.Poll(Int32, SelectMode)
>>
>
> RTFM. Socket.Poll *waits* for a socket. Obviously it's going to spend quite
> a bit of time.
>
> Note that it is "wall time", not "CPU time".
>
> You would be better investigating whatever is at the other end of the
> socket, which I presume is Postgres. Look at what the queries actually are,
> and try EXPLAIN ANALYSE on a few.
>
> Matthew
>
> --
> It is better to keep your mouth closed and let people think you are a fool
> than to open it and remove all doubt. -- Mark Twain

--
Thanks,
Keshav Upadhyaya