From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, vromanov(at)gmail(dot)com, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: ODBC Driver performance comparison |
Date: | 2014-09-15 03:34:01 |
Message-ID: | 54165E29.4020601@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 09/05/2014 02:40 PM, Heikki Linnakangas wrote:
> Are you measuring wall-clock time or CPU time? If it's CPU time, I'm
> surprised that the I/O-related syscalls, poll(), send() and recv(), are
> so high on the profile. If not, there isn't much you can do in the
> client side to make them faster, as the time is simply spent waiting for
> the server.
There's still potentially one big thing that can be done: reduce
round-trips.
For example, the PgJDBC driver sends multi-statements to the server by
writing a bunch of bind/parse/execute messsages, *then* waiting for a
response and processing each response as it receives it.
It can be worth looking at what's happening on the wire.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Vaughn, Ben | 2014-09-15 18:16:11 | FW: error |
Previous Message | Michael Paquier | 2014-09-12 05:21:07 | Re: [ODBC] 2014年9月12日 9:19:57 自动保存草稿 |