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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-10-10 10:02:46 | Re: New release of psqODBC? |
Previous Message | Dmitriy Ivanov | 2006-10-07 05:23:09 | Re: Representing Empty DATE values as NULL |