Performance » History » Revision 4
« Previous |
Revision 4/5
(diff)
| Next »
bford -, 10/09/2006 06:11 PM
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
}}}
Updated by bford - about 18 years ago · 4 revisions