91 lines
3.4 KiB
Plaintext
91 lines
3.4 KiB
Plaintext
|
---- 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
|