Project

General

Profile

Edit History

Performance » History » Version 2

bford -, 09/28/2006 01:54 PM

1 1 bford - 
The follow are the results of some basic tests run on 09/28/06:
2 





    3
    
    
    
{{{





    4
    2
    bford -
    





    5
    1
    bford -
    
==========================================================





    6
    
    
    
DBD::Pg





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





    8
    
    
    
Start: 01:43:05 PM





    9
    
    
    
 Selecting 1000000 rowsEnd: 01:43:08 PM





    10
    1
    bford -
    





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





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





    13
    1
    bford -
    





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





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





    16
    1
    bford -
    





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





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





    19
    1
    bford -
    





    20
    
    
    
==========================================================





    21
    
    
    
DBD::nodbcng_nobuffer





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





    23
    
    
    
Start: 01:45:53 PM





    24
    
    
    
 Selecting 1000000 rowsEnd: 01:45:56 PM





    25
    1
    bford -
    





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





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





    28
    1
    bford -
    





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





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





    31
    1
    bford -
    





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





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





    34
    1
    bford -
    





    35
    
    
    
==========================================================





    36
    
    
    
DBD::odbcng_buffer





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





    38
    
    
    
Start: 01:48:44 PM





    39
    
    
    
 Selecting 1000000 rowsEnd: 01:48:48 PM





    40
    1
    bford -
    





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





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





    43
    1
    bford -
    





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





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





    46
    1
    bford -
    





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





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





    49
    1
    bford -
    





    50
    
    
    
==========================================================





    51
    
    
    
DBD::PGDG.ODBC





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





    53
    
    
    
Start: 01:51:38 PM





    54
    
    
    
 Selecting 1000000 rowsEnd: 01:51:42 PM





    55
    1
    bford -
    





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





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





    58
    1
    bford -
    





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





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





    61
    1
    bford -
    





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





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





    64
    1
    bford -
    





    65
    
    
    





    66
    
    
    
}}}