=======================
 == odbc-bench-1.0.0x == to PostgreSQL Ver 8.4.2
 =======================

C:\BENCH_MIMER>odbc_bench -d PostgreSQL30A -u postgres -p postgres -C -V

Connecting to CommandLine : DSN=<PostgreSQL30A> UID=<postgres>
Driver : 08.04.0200 (PSQLODBC.DLL)
Connection to CommandLine opened

Building Table Definition for 'BRANCH'.
Building Table Definition for 'TELLER'.
Building Table Definition for 'ACCOUNT'.
Building Table Definition for 'HISTORY'.

create unique index BRANCHix on BRANCH(BRANCH)
create unique index TELLERix on TELLER(TELLER)
create unique index ACCOUNTix on ACCOUNT(ACCOUNT)

Dropping procedures
Adding a procedure for PostgreSQL

Benchmark Loader Status

REMAIN
======
Attempting to load 10 records into BRANCH table
10 rows actually copied.

Benchmark Loader Status

REMAIN
======
Attempting to load 100 records into TELLER table
100 rows actually copied.

Benchmark Loader Status

REMAIN
======
Attempting to load 1000 records into ACCOUNT table
1000 rows actually copied.

Connection to CommandLine closed

C:\BENCH_MIMER>odbc_bench -d PostgreSQL30A -u postgres -p postgres -r 1 -t
 4 -s prepare -c keyset -S 5 -K 5 -V

Connecting to CommandLine : DSN=<PostgreSQL30A> UID=<postgres>
Driver : 08.04.0200 (PSQLODBC.DLL)
Connection to CommandLine opened
Connection to CommandLine closed

Command Line

REMAIN   THR 1    THR 2    THR 3    THR 4
==========================================
     0     3690     3530     4070     3920 TPS=253.500000

Connecting to CommandLine : DSN=<PostgreSQL30A> UID=<postgres>
Driver : 08.04.0200 (PSQLODBC.DLL)
Connection to CommandLine opened

CommandLine - PostgreSQL(PSQLODBC.DLL) - all 4 TPC-A Threads completed successfu
lly.
Calculating statistics:
        SQL options used:                       4 Threads/Params
        Transaction time:                       61.000000
        Environmental overhead:                 -1.000000
        Total transactions:                     15236
        Transactions per second:                249.770493
        % less than 1 second:                   99.973747
        % 1 < n < 2 seconds:                    0.026254
        Average processing time:                0.004004
Connection to CommandLine closed

============================================================================================

C:\BENCH_MIMER>odbc_bench -d PostgreSQL35W -u postgres -p postgres -C -V

Connecting to CommandLine : DSN=<PostgreSQL35W> UID=<postgres>
Driver : 08.04.0200 (PSQLODBC35W.DLL)
Connection to CommandLine opened

Building Table Definition for 'BRANCH'.
Building Table Definition for 'TELLER'.
Building Table Definition for 'ACCOUNT'.
Building Table Definition for 'HISTORY'.

create unique index BRANCHix on BRANCH(BRANCH)
create unique index TELLERix on TELLER(TELLER)
create unique index ACCOUNTix on ACCOUNT(ACCOUNT)

Dropping procedures
Adding a procedure for PostgreSQL

Benchmark Loader Status

REMAIN
======
Attempting to load 10 records into BRANCH table
10 rows actually copied.

Benchmark Loader Status

REMAIN
======
Attempting to load 100 records into TELLER table
100 rows actually copied.

Benchmark Loader Status

REMAIN
======
Attempting to load 1000 records into ACCOUNT table
1000 rows actually copied.

Connection to CommandLine closed

C:\BENCH_MIMER>odbc_bench -d PostgreSQL35W -u postgres -p postgres -r 1 -t
 4 -s prepare -c keyset -S 5 -K 5 -V

Connecting to CommandLine : DSN=<PostgreSQL35W> UID=<postgres>
Driver : 08.04.0200 (PSQLODBC35W.DLL)
Connection to CommandLine opened
Connection to CommandLine closed

Command Line

REMAIN   THR 1    THR 2    THR 3    THR 4
==========================================
     0     3800     3790     3730     3800 TPS=252.000000

Connecting to CommandLine : DSN=<PostgreSQL35W> UID=<postgres>
Driver : 08.04.0200 (PSQLODBC35W.DLL)
Connection to CommandLine opened


CommandLine - PostgreSQL(PSQLODBC35W.DLL) - all 4 TPC-A Threads completed succes
sfully.
Calculating statistics:
        SQL options used:                       4 Threads/Params
        Transaction time:                       61.000000
        Environmental overhead:                 -1.000000
        Total transactions:                     15145
        Transactions per second:                248.278687
        % less than 1 second:                   99.973587
        % 1 < n < 2 seconds:                    0.026411
        Average processing time:                0.004028
Connection to CommandLine closed

[ICO]NameLast modifiedSizeDescription

[PARENTDIR]Parent Directory   -  
[DIR]check/ 2011-07-13 22:16 -  
[   ]odbc-bench-1.0.0x.zip 2010-07-02 00:43 1.2M