Skip site navigation (1) Skip section navigation (2)

Re: PGDG ODBC, ODBCng, DBD::Pg

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: PGDG ODBC, ODBCng, DBD::Pg
Date: 2006-10-09 21:26:37
Message-ID: 452ABE8D.6030007@commandprompt.com (view raw or flat)
Thread:
Lists: 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(at)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/



In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2006-10-10 10:02:46
Subject: Re: New release of psqODBC?
Previous:From: Dmitriy IvanovDate: 2006-10-07 05:23:09
Subject: Re: Representing Empty DATE values as NULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group