Performance » History » Revision 4
Revision 3 (bford -, 09/28/2006 01:58 PM) → Revision 4/5 (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 follow 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 }}}