---- Base:
florian/florian@hera

---- Table:
CREATE TABLE dummy (c1 NUMBER(35) NOT NULL PRIMARY KEY,
                    c2 VARCHAR2(16),
                    c3 NUMBER(10));
                                        
---- Query:
"INSERT INTO dummy (c1, c2, c3) VALUES (:1, :2, :3)"

:1 range from 1 to N
:2 range from 'B1' to 'BN'
:3 range from 1 to N

---- Time Results (seconds):

    N   | Empty table     | after 1 shot    | after 2 shots   | rows/sec
--------------------------------------------------------------------------------------------
    10  | (ms) 2.19; 1.79; 3.69; 1.76       |                 | 4500 ~ 5600
   100  | (ms) 6.8; 10.5; 8.0;              |                 | 9500 ~ 14700
 1 000  | (ms) 68.3; 80.7; 79.1;            |                 | 12800 ~ 14600
10 000  | 1.5; 1.2; 1.1   | 1.4; 1.4; 1.3   | 1.1; 1.1; 1.3   | 6600 ~ 9000
50 000  | 7.1; 6.8; 7.1   | 6.4; 8.0; 7.3   | 9.3; 8.0; 6.9   | 5300 ~ 7800
65 536  | 12.8; 12.6      | 11.5; 11.6;     | 11.3;           | 5120 ~ 5800
--------------------------------------------------------------------------------------------


---- Query:
"SELECT c1, c2, c3 FROM dummy"

Select 100 000 rows in 2.7 sec. --> 35000 rows/sec
Select 100 000 rows in 2.3 sec. --> 43000 rows/sec

---- Query:
"SELECT c1, c2, c3 FROM dummy WHERE c1 > 0 and c3 < 1234567"

Select 100 000 rows in 9.5 sec. --> 10500 rows/sec
Select 100 000 rows in 9.6 sec. --> 10400 rows/sec


######################################################################################


---- Base:
entr/entr@pbdme1


---- Table:
TB_PERSONNE_PHYSIQUE & test_ens

[ CREATE TABLE test_ens (CT_PERSONNE_PHYSIQUE NOT NULL NUMBER(35),
                         NUM_PP NOT NULL CHAR(7), DAT_DER_MAJ_BDM DATE, .......) ]

---- Query:                       
"SELECT CT_PERSONNE_PHYSIQUE, NUM_PP, DAT_DER_MAJ_BDM FROM tb_personne_physique"

Select 11000 rows in 2.7 sec. --> 4000 rows/sec
Select 11000 rows in 2.5 sec. --> 4400 rows/sec
Select 11000 rows in 2.4 sec. --> 4500 rows/sec

Select 50000 rows in 11.6 sec. --> 4300 rows/sec
Select 50000 rows in 11.4 sec. --> 4400 rows/sec


---- Query:
"INSERT INTO test_ens (CT_PERSONNE_PHYSIQUE, NUM_PP, DAT_DER_MAJ_BDM) VALUES (:1, :2, :3)"
Input values taken from table "tb_personne_physique" as shown above.


---- Time Results (seconds):

    N   | Empty table     | after 1 shot    | after 2 shots   | rows/sec
--------------------------------------------------------------------------------------------
10 000  | 1.1; 1.3; 1.2   | 1.3;            | 1.2;            | 7000 ~ 9000
50 000  | 5.9; 5.9; 6.2   | 6.4;            | 6.0;            | 7800 ~ 8400
--------------------------------------------------------------------------------------------

Insert N rows of 38 columns:

    N   |                                   | rows/sec
--------------------------------------------------------------------------------------------
   100  | 0.10; 0.11; 0.10;                 |  877 ~ 980
   500  | 0.47; 0.41; 0.42;                 | 1060 ~ 1219
 1 000  | 0.87; 0.81; 0.83;                 | 1100 ~ 1200
 2 000  | 7.93; 8.29; 8.23;                 | 1200 ~ 1260 
10 000  | 8.01; 7.98; 8.26;                 | 1200 ~ 1250
15 000  | 15.8; 16.3; 16.4;                 |  914 ~ 949
--------------------------------------------------------------------------------------------

Select 20000 rows in 38.6 sec. --> 518 rows/sec