Anecdotal JDBC vs ODBC bulk export performance

From: John Kew <jkew(at)tableau(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Anecdotal JDBC vs ODBC bulk export performance
Date: 2016-01-04 20:37:37
Message-ID: CY1PR0301MB197884AF4ADFD99644E9E902CCF20@CY1PR0301MB1978.namprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

The open source JDBC driver appears to outperform the ODBC driver when executing bulk extract queries of the form: "SELECT * from [Blah] Limit [n]" - We are just measuring the raw rows per second from this query for pulling all the rows out. After playing with the FetchSize in the ODBC driver we have improved performance significantly but are there any other techniques; tools or tips which you would suggest for further improving performance?

ReadOnly does not appear to have a significant effect. The JDBC connection string is using the default settings and setFetchSize is not called on the JDBC driver. We have not yet started profiling the ODBC driver. For this quick test we are also not using column binding on the ODBC side; but we are calling SQLFetch to count the total # of rows returned. Essentially the same thing occurs on the JDBC side.

-John

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Cramer 2016-01-05 11:36:37 Re: Anecdotal JDBC vs ODBC bulk export performance
Previous Message Adrian Klaver 2015-12-28 15:42:56 Re: psqlODBC 08.03- Supportability