Re: PGDG ODBC, ODBCng, DBD::Pg - Mailing list pgsql-odbc
From | Joshua D. Drake |
---|---|
Subject | Re: PGDG ODBC, ODBCng, DBD::Pg |
Date | |
Msg-id | 452ABE8D.6030007@commandprompt.com Whole thread Raw |
In response to | Re: PGDG ODBC, ODBCng, DBD::Pg ("Joshua D. Drake" <jd@commandprompt.com>) |
List | pgsql-odbc |
Joshua D. Drake wrote: >>> The versions tested were: >>> >>> PGDG: 08.01.0200-2 >>> ODBCng: Rev 76 >>> DBD::Pg: 1.49 >> Any chance of running the same test again against psqlODBC 08.02.0100? >> It's a totally different architecture to the 08.01 series. >> >> You might also try something like odbc-bench for some more realistic >> tests. > > Either I am cranked, or odbc-bench doesn't appear to support > postgresql... do you a compatible schema for them? Dave per your request, PostgreSQL ODBC versus ODBCng. Unfortunately I couldn't test with 08.02 because I am on 64bit. I ran 6 tests. The tests are identical except: Async: ODBCng ODBCng Buffering mode PostgreSQL ODBC Not Async: ODBCng ODBCng Buffering mode PostgreSQL ODBC jd@scratch:~/ODBCtest$ ./testodbc.pl ========================================================== Initializing ODBC-Bench Done ODBCng Buffering Async ========================================================== Connecting to CommandLine : DSN=<odbcng_buffer> UID=<postgres> Driver : 00.99.0067 (libmodbc.so) Connection to CommandLine opened Connection to CommandLine closed Connecting to CommandLine : DSN=<odbcng_buffer> UID=<postgres> Driver : 00.99.0067 (libmodbc.so) Connection to CommandLine opened CommandLine - PostgreSQL(libmodbc.so) - all 10 TPC-A Threads completed successfully. Calculating statistics: SQL options used: 10 Threads/Async/Params Transaction time: 61.000000 Environmental overhead: -1.000000 Total transactions: 66224 Transactions per second: 1085.639404 % less than 1 second: 99.983391 % 1 < n < 2 seconds: 0.016610 Average processing time: 0.000921 Connection to CommandLine closed ========================================================== ODBCng No Buffering Async ========================================================== Connecting to CommandLine : DSN=<odbcng_nobuffer> UID=<postgres> Driver : 00.99.0067 (libmodbc.so) Connection to CommandLine opened Connection to CommandLine closed Connecting to CommandLine : DSN=<odbcng_nobuffer> UID=<postgres> Driver : 00.99.0067 (libmodbc.so) Connection to CommandLine opened CommandLine - PostgreSQL(libmodbc.so) - all 10 TPC-A Threads completed successfully. Calculating statistics: SQL options used: 10 Threads/Async/Params Transaction time: 61.000000 Environmental overhead: -1.000000 Total transactions: 63063 Transactions per second: 1033.819702 % less than 1 second: 99.976212 % 1 < n < 2 seconds: 0.023786 Average processing time: 0.000967 Connection to CommandLine closed ========================================================== PostgreSQL ODBC Async ========================================================== Connecting to CommandLine : DSN=<pgdg> UID=<postgres> Driver : 08.01.0200 (libpsqlodbc.so) Connection to CommandLine opened Connection to CommandLine closed Connecting to CommandLine : DSN=<pgdg> UID=<postgres> Driver : 08.01.0200 (libpsqlodbc.so) Connection to CommandLine opened CommandLine - PostgreSQL(libpsqlodbc.so) - all 10 TPC-A Threads completed successfully. Calculating statistics: SQL options used: 10 Threads/Async/Params Transaction time: 61.000000 Environmental overhead: -1.000000 Total transactions: 37317 Transactions per second: 611.754089 % less than 1 second: 99.965164 % 1 < n < 2 seconds: 0.034837 Average processing time: 0.001635 Connection to CommandLine closed ========================================================== ODBCng Buffering ========================================================== Connecting to CommandLine : DSN=<odbcng_buffer> UID=<postgres> Driver : 00.99.0067 (libmodbc.so) Connection to CommandLine opened Connection to CommandLine closed Connecting to CommandLine : DSN=<odbcng_buffer> UID=<postgres> Driver : 00.99.0067 (libmodbc.so) Connection to CommandLine opened CommandLine - PostgreSQL(libmodbc.so) - all 10 TPC-A Threads completed successfully. Calculating statistics: SQL options used: 10 Threads/Params Transaction time: 61.000000 Environmental overhead: -1.000000 Total transactions: 64843 Transactions per second: 1063.000000 % less than 1 second: 99.976868 % 1 < n < 2 seconds: 0.023133 Average processing time: 0.000941 Connection to CommandLine closed ========================================================== ODBCng No Buffering ========================================================== Connecting to CommandLine : DSN=<odbcng_nobuffer> UID=<postgres> Driver : 00.99.0067 (libmodbc.so) Connection to CommandLine opened Connection to CommandLine closed Connecting to CommandLine : DSN=<odbcng_nobuffer> UID=<postgres> Driver : 00.99.0067 (libmodbc.so) Connection to CommandLine opened CommandLine - PostgreSQL(libmodbc.so) - all 10 TPC-A Threads completed successfully. Calculating statistics: SQL options used: 10 Threads/Params Transaction time: 61.000000 Environmental overhead: -1.000000 Total transactions: 63025 Transactions per second: 1033.196777 % less than 1 second: 99.979370 % 1 < n < 2 seconds: 0.020627 Average processing time: 0.000968 Connection to CommandLine closed ========================================================== PostgreSQL ODBC ========================================================== Connecting to CommandLine : DSN=<pgdg> UID=<postgres> Driver : 08.01.0200 (libpsqlodbc.so) Connection to CommandLine opened Connection to CommandLine closed Connecting to CommandLine : DSN=<pgdg> UID=<postgres> Driver : 08.01.0200 (libpsqlodbc.so) Connection to CommandLine opened CommandLine - PostgreSQL(libpsqlodbc.so) - all 10 TPC-A Threads completed successfully. Calculating statistics: SQL options used: 10 Threads/Params Transaction time: 61.000000 Environmental overhead: -1.000000 Total transactions: 35435 Transactions per second: 580.901611 % less than 1 second: 99.932274 % 1 < n < 2 seconds: 0.067730 Average processing time: 0.001721 Connection to CommandLine closed ========================================================= -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/
pgsql-odbc by date: