Performance - Odbcng - public.commandprompt.com

Actions

History

The following tests were run on 10/09/06 using odbc-bench:

==========================================================
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 following are the results of some basic tests run on 09/28/06:


==========================================================
DBD::Pg
Cleaning up before test, Truncating insert_test, Analyzing test
Start: 01:43:05 PM
 Selecting 1000000 rows End: 01:43:08 PM

Start: 01:43:08 PM
 Insert 1000000 rows 1000 at a time End: 01:43:18 PM

Start: 01:43:18 PM
 Insert 1000000 rows one at a time End: 01:45:16 PM

Start: 01:45:16 PM
 Insert 1000000 prepared rows 1000 at a time End: 01:45:23 PM

==========================================================
DBD::nodbcng_nobuffer
Cleaning up before test, Truncating insert_test, Analyzing test
Start: 01:45:53 PM
 Selecting 1000000 rows End: 01:45:56 PM

Start: 01:45:56 PM
 Insert 1000000 rows 1000 at a time End: 01:46:05 PM

Start: 01:46:05 PM
 Insert 1000000 rows one at a time End: 01:48:07 PM

Start: 01:48:07 PM
 Insert 1000000 prepared rows 1000 at a time End: 01:48:14 PM

==========================================================
DBD::odbcng_buffer
Cleaning up before test, Truncating insert_test, Analyzing test
Start: 01:48:44 PM
 Selecting 1000000 rows End: 01:48:48 PM

Start: 01:48:48 PM
 Insert 1000000 rows 1000 at a time End: 01:48:57 PM

Start: 01:48:57 PM
 Insert 1000000 rows one at a time End: 01:51:00 PM

Start: 01:51:00 PM
 Insert 1000000 prepared rows 1000 at a time End: 01:51:08 PM

==========================================================
DBD::PGDG.ODBC
Cleaning up before test, Truncating insert_test, Analyzing test
Start: 01:51:38 PM
 Selecting 1000000 rows End: 01:51:42 PM

Start: 01:51:42 PM
 Insert 1000000 rows 1000 at a time End: 01:51:52 PM

Start: 01:51:52 PM
 Insert 1000000 rows one at a time End: 01:53:46 PM

Start: 01:53:46 PM
 Insert 1000000 prepared rows 1000 at a time End: 01:53:54 PM

Files (0)

Updated by bford - over 17 years ago · 5 revisions

Project

General

Profile

Odbcng

Wiki