Project

General

Profile

Edit History

Performance » History » Version 5

bford -, 10/09/2006 06:11 PM

1 4 bford - 
The following tests were run on 10/09/06 using odbc-bench:
2 





    3
    5
    bford -
    
<pre>





    4
    4
    bford -
    
==========================================================





    5
    
    
    
Initializing ODBC-Bench





    6
    
    
    
Done





    7
    
    
    
ODBCng Buffering Async





    8
    
    
    
==========================================================





    9
    
    
    





    10
    
    
    





    11
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<odbcng_buffer> UID=<postgres>





    12
    4
    bford -
    
Driver : 00.99.0067 (libmodbc.so)





    13
    5
    bford -
    
Connection to [[CommandLine]] opened





    14
    4
    bford -
    





    15
    5
    bford -
    
Connection to [[CommandLine]] closed





    16
    4
    bford -
    





    17
    
    
    





    18
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<odbcng_buffer> UID=<postgres>





    19
    4
    bford -
    
Driver : 00.99.0067 (libmodbc.so)





    20
    5
    bford -
    
Connection to [[CommandLine]] opened





    21
    4
    bford -
    





    22
    
    
    





    23
    
    
    





    24
    5
    bford -
    
[[CommandLine]] - [[PostgreSQL]](libmodbc.so) - all 10 TPC-A Threads completed





    25
    4
    bford -
    
successfully.





    26
    
    
    
Calculating statistics:





    27
    
    
    
        SQL options used:                       10 Threads/Async/Params





    28
    
    
    
        Transaction time:                       61.000000





    29
    
    
    
        Environmental overhead:                 -1.000000





    30
    
    
    
        Total transactions:                     66224





    31
    
    
    
        Transactions per second:                1085.639404





    32
    
    
    
        % less than 1 second:                   99.983391





    33
    
    
    
        % 1 < n < 2 seconds:                    0.016610





    34
    
    
    
        Average processing time:                0.000921





    35
    5
    bford -
    
Connection to [[CommandLine]] closed





    36
    4
    bford -
    
==========================================================





    37
    
    
    
ODBCng No Buffering Async





    38
    
    
    
==========================================================





    39
    
    
    





    40
    
    
    





    41
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<odbcng_nobuffer> UID=<postgres>





    42
    4
    bford -
    
Driver : 00.99.0067 (libmodbc.so)





    43
    5
    bford -
    
Connection to [[CommandLine]] opened





    44
    4
    bford -
    





    45
    5
    bford -
    
Connection to [[CommandLine]] closed





    46
    4
    bford -
    





    47
    
    
    





    48
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<odbcng_nobuffer> UID=<postgres>





    49
    4
    bford -
    
Driver : 00.99.0067 (libmodbc.so)





    50
    5
    bford -
    
Connection to [[CommandLine]] opened





    51
    4
    bford -
    





    52
    
    
    





    53
    
    
    





    54
    5
    bford -
    
[[CommandLine]] - [[PostgreSQL]](libmodbc.so) - all 10 TPC-A Threads completed





    55
    4
    bford -
    
successfully.





    56
    
    
    
Calculating statistics:





    57
    
    
    
        SQL options used:                       10 Threads/Async/Params





    58
    
    
    
        Transaction time:                       61.000000





    59
    
    
    
        Environmental overhead:                 -1.000000





    60
    
    
    
        Total transactions:                     63063





    61
    
    
    
        Transactions per second:                1033.819702





    62
    
    
    
        % less than 1 second:                   99.976212





    63
    
    
    
        % 1 < n < 2 seconds:                    0.023786





    64
    
    
    
        Average processing time:                0.000967





    65
    5
    bford -
    
Connection to [[CommandLine]] closed





    66
    4
    bford -
    
==========================================================





    67
    5
    bford -
    
[[PostgreSQL]] ODBC Async





    68
    4
    bford -
    
==========================================================





    69
    
    
    





    70
    
    
    





    71
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<pgdg> UID=<postgres>





    72
    4
    bford -
    
Driver : 08.01.0200 (libpsqlodbc.so)





    73
    5
    bford -
    
Connection to [[CommandLine]] opened





    74
    4
    bford -
    





    75
    5
    bford -
    
Connection to [[CommandLine]] closed





    76
    4
    bford -
    





    77
    
    
    





    78
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<pgdg> UID=<postgres>





    79
    4
    bford -
    
Driver : 08.01.0200 (libpsqlodbc.so)





    80
    5
    bford -
    
Connection to [[CommandLine]] opened





    81
    4
    bford -
    





    82
    
    
    





    83
    
    
    





    84
    5
    bford -
    
[[CommandLine]] - [[PostgreSQL]](libpsqlodbc.so) - all 10 TPC-A Threads





    85
    4
    bford -
    
completed successfully.





    86
    
    
    
Calculating statistics:





    87
    
    
    
        SQL options used:                       10 Threads/Async/Params





    88
    
    
    
        Transaction time:                       61.000000





    89
    
    
    
        Environmental overhead:                 -1.000000





    90
    
    
    
        Total transactions:                     37317





    91
    
    
    
        Transactions per second:                611.754089





    92
    
    
    
        % less than 1 second:                   99.965164





    93
    
    
    
        % 1 < n < 2 seconds:                    0.034837





    94
    
    
    
        Average processing time:                0.001635





    95
    5
    bford -
    
Connection to [[CommandLine]] closed





    96
    4
    bford -
    
==========================================================





    97
    
    
    
ODBCng Buffering





    98
    
    
    
==========================================================





    99
    
    
    





    100
    
    
    





    101
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<odbcng_buffer> UID=<postgres>





    102
    4
    bford -
    
Driver : 00.99.0067 (libmodbc.so)





    103
    5
    bford -
    
Connection to [[CommandLine]] opened





    104
    4
    bford -
    





    105
    5
    bford -
    
Connection to [[CommandLine]] closed





    106
    4
    bford -
    





    107
    
    
    





    108
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<odbcng_buffer> UID=<postgres>





    109
    4
    bford -
    
Driver : 00.99.0067 (libmodbc.so)





    110
    5
    bford -
    
Connection to [[CommandLine]] opened





    111
    4
    bford -
    





    112
    
    
    





    113
    
    
    





    114
    5
    bford -
    
[[CommandLine]] - [[PostgreSQL]](libmodbc.so) - all 10 TPC-A Threads completed





    115
    4
    bford -
    
successfully.





    116
    
    
    
Calculating statistics:





    117
    
    
    
        SQL options used:                       10 Threads/Params





    118
    
    
    
        Transaction time:                       61.000000





    119
    
    
    
        Environmental overhead:                 -1.000000





    120
    
    
    
        Total transactions:                     64843





    121
    
    
    
        Transactions per second:                1063.000000





    122
    
    
    
        % less than 1 second:                   99.976868





    123
    
    
    
        % 1 < n < 2 seconds:                    0.023133





    124
    
    
    
        Average processing time:                0.000941





    125
    5
    bford -
    
Connection to [[CommandLine]] closed





    126
    4
    bford -
    
==========================================================





    127
    
    
    
ODBCng No Buffering





    128
    
    
    
==========================================================





    129
    
    
    





    130
    
    
    





    131
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<odbcng_nobuffer> UID=<postgres>





    132
    4
    bford -
    
Driver : 00.99.0067 (libmodbc.so)





    133
    5
    bford -
    
Connection to [[CommandLine]] opened





    134
    4
    bford -
    





    135
    5
    bford -
    
Connection to [[CommandLine]] closed





    136
    4
    bford -
    





    137
    
    
    





    138
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<odbcng_nobuffer> UID=<postgres>





    139
    4
    bford -
    
Driver : 00.99.0067 (libmodbc.so)





    140
    5
    bford -
    
Connection to [[CommandLine]] opened





    141
    4
    bford -
    





    142
    
    
    





    143
    
    
    





    144
    5
    bford -
    
[[CommandLine]] - [[PostgreSQL]](libmodbc.so) - all 10 TPC-A Threads completed





    145
    4
    bford -
    
successfully.





    146
    
    
    
Calculating statistics:





    147
    
    
    
        SQL options used:                       10 Threads/Params





    148
    
    
    
        Transaction time:                       61.000000





    149
    
    
    
        Environmental overhead:                 -1.000000





    150
    
    
    
        Total transactions:                     63025





    151
    
    
    
        Transactions per second:                1033.196777





    152
    
    
    
        % less than 1 second:                   99.979370





    153
    
    
    
        % 1 < n < 2 seconds:                    0.020627





    154
    
    
    
        Average processing time:                0.000968





    155
    5
    bford -
    
Connection to [[CommandLine]] closed





    156
    4
    bford -
    
==========================================================





    157
    5
    bford -
    
[[PostgreSQL]] ODBC





    158
    4
    bford -
    
==========================================================





    159
    
    
    





    160
    
    
    





    161
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<pgdg> UID=<postgres>





    162
    4
    bford -
    
Driver : 08.01.0200 (libpsqlodbc.so)





    163
    5
    bford -
    
Connection to [[CommandLine]] opened





    164
    4
    bford -
    





    165
    5
    bford -
    
Connection to [[CommandLine]] closed





    166
    4
    bford -
    





    167
    
    
    





    168
    5
    bford -
    
Connecting to [[CommandLine]] : DSN=<pgdg> UID=<postgres>





    169
    4
    bford -
    
Driver : 08.01.0200 (libpsqlodbc.so)





    170
    5
    bford -
    
Connection to [[CommandLine]] opened





    171
    4
    bford -
    





    172
    
    
    





    173
    
    
    





    174
    5
    bford -
    
[[CommandLine]] - [[PostgreSQL]](libpsqlodbc.so) - all 10 TPC-A Threads





    175
    4
    bford -
    
completed successfully.





    176
    
    
    
Calculating statistics:





    177
    
    
    
        SQL options used:                       10 Threads/Params





    178
    
    
    
        Transaction time:                       61.000000





    179
    
    
    
        Environmental overhead:                 -1.000000





    180
    
    
    
        Total transactions:                     35435





    181
    
    
    
        Transactions per second:                580.901611





    182
    
    
    
        % less than 1 second:                   99.932274





    183
    
    
    
        % 1 < n < 2 seconds:                    0.067730





    184
    
    
    
        Average processing time:                0.001721





    185
    5
    bford -
    
Connection to [[CommandLine]] closed





    186
    4
    bford -
    





    187
    
    
    
=========================================================





    188
    
    
    





    189
    5
    bford -
    
</pre>





    190
    4
    bford -
    





    191
    
    
    
The following are the results of some basic tests run on 09/28/06:





    192
    1
    bford -
    





    193
    5
    bford -
    
<pre>





    194
    2
    bford -
    





    195
    1
    bford -
    
==========================================================





    196
    
    
    
DBD::Pg





    197
    2
    bford -
    
Cleaning up before test, Truncating insert_test, Analyzing test





    198
    
    
    
Start: 01:43:05 PM





    199
    3
    bford -
    
 Selecting 1000000 rows End: 01:43:08 PM





    200
    1
    bford -
    





    201
    2
    bford -
    
Start: 01:43:08 PM





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





    203
    1
    bford -
    





    204
    2
    bford -
    
Start: 01:43:18 PM





    205
    
    
    
 Insert 1000000 rows one at a time End: 01:45:16 PM





    206
    1
    bford -
    





    207
    2
    bford -
    
Start: 01:45:16 PM





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





    209
    1
    bford -
    





    210
    
    
    
==========================================================





    211
    
    
    
DBD::nodbcng_nobuffer





    212
    2
    bford -
    
Cleaning up before test, Truncating insert_test, Analyzing test





    213
    
    
    
Start: 01:45:53 PM





    214
    3
    bford -
    
 Selecting 1000000 rows End: 01:45:56 PM





    215
    1
    bford -
    





    216
    2
    bford -
    
Start: 01:45:56 PM





    217
    
    
    
 Insert 1000000 rows 1000 at a time End: 01:46:05 PM





    218
    1
    bford -
    





    219
    2
    bford -
    
Start: 01:46:05 PM





    220
    
    
    
 Insert 1000000 rows one at a time End: 01:48:07 PM





    221
    1
    bford -
    





    222
    2
    bford -
    
Start: 01:48:07 PM





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





    224
    1
    bford -
    





    225
    
    
    
==========================================================





    226
    
    
    
DBD::odbcng_buffer





    227
    2
    bford -
    
Cleaning up before test, Truncating insert_test, Analyzing test





    228
    
    
    
Start: 01:48:44 PM





    229
    3
    bford -
    
 Selecting 1000000 rows End: 01:48:48 PM





    230
    1
    bford -
    





    231
    2
    bford -
    
Start: 01:48:48 PM





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





    233
    1
    bford -
    





    234
    2
    bford -
    
Start: 01:48:57 PM





    235
    
    
    
 Insert 1000000 rows one at a time End: 01:51:00 PM





    236
    1
    bford -
    





    237
    2
    bford -
    
Start: 01:51:00 PM





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





    239
    1
    bford -
    





    240
    
    
    
==========================================================





    241
    
    
    
DBD::PGDG.ODBC





    242
    2
    bford -
    
Cleaning up before test, Truncating insert_test, Analyzing test





    243
    
    
    
Start: 01:51:38 PM





    244
    3
    bford -
    
 Selecting 1000000 rows End: 01:51:42 PM





    245
    1
    bford -
    





    246
    2
    bford -
    
Start: 01:51:42 PM





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





    248
    1
    bford -
    





    249
    2
    bford -
    
Start: 01:51:52 PM





    250
    
    
    
 Insert 1000000 rows one at a time End: 01:53:46 PM





    251
    1
    bford -
    





    252
    2
    bford -
    
Start: 01:53:46 PM





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





    254
    1
    bford -
    





    255
    
    
    





    256
    5
    bford -
    
</pre>