Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()
| От | keshav upadhyaya |
|---|---|
| Тема | Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll() |
| Дата | |
| Msg-id | d40c44910910150740w4cb805b4j8bdf0a87abf5d39c@mail.gmail.com обсуждение исходный текст |
| Ответ на | Regarding facing lot of time Consumed by Socket.Poll() (keshav upadhyaya <ukeshav2009@gmail.com>) |
| Список | pgsql-novice |
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
--
Thanks,
Keshav Upadhyaya
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:RTFM. Socket.Poll *waits* for a socket. Obviously it's going to spend quite a bit of time.[Wall Time] System.Net.Sockets.Socket.Poll(Int32, SelectMode)
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
В списке pgsql-novice по дате отправления: