Running latest release of PostgreSQL ODBC Driver (8.02.0200).
Does the ODBC driver for Windows use connection pooling?
I have a Windows application which is using the driver.
I have connection pooling enabled, and the application notifies the
driver to use connection pooling (per the developer).
I saw a huge disparity when running the queries (a stored procedure
call) via psql locally and via the odbc driver (in this case, I am
referring to the statement duration as logged by postgresql). The call
being made is a "select * from sp_name(parameters)".
I have about an 8:1 performance degradation in the statement duration
when called via ODBC compared to directly in psql (as reported by the
postgres log file).
I have not tried running the query through pgAdmin to see what execution
speed I get.
However, when I turned connection loggin on, I noticed that every single
call to the stored procedure is creating a new connection (so it appears
it is not honoring the connection pooling, which I believe results in
quite a bit of overhead for each statement being called).
TIA,
Benjamin
