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@cam.ac.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