ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Primary Key, record found
Timer code
3
1st passcl_abap_runtime=>create_hr_timer( )
4
Up to 1 row8240816421,169->get_runtime( )
5
Select single returning row
8240816515,340
6
Using Count (*)
Record was found
2,187Primary Key Test
No Primary Key (Date changed for failed selects)
7
Using SELECT SINGLE @abap_true
Record was found
10,969Upto 1 row (Note: Changed POSNR for not found test)
8
2nd passSELECT * FROM lips INTO TABLE li_lipsSELECT * FROM lips INTO TABLE li_lips
9
Up to 1 row82408164709UP TO 1 ROWS BYPASSING BUFFERUP TO 1 ROWS BYPASSING BUFFER
10
Select single returning row
82408165551WHERE vbeln = '0082408164'WHERE erdat = '20160615'.
11
Using Count (*)
Record was found
316AND POSNR = '000010'.
12
Using SELECT SINGLE @abap_true
Record was found
332
13
Select Single returning row
14
Primary Key, record not found
SELECT SINGLE * FROM lips INTO l_lipsSELECT SINGLE * FROM lips INTO l_lips
15
1st passBYPASSING BUFFERBYPASSING BUFFER
16
Up to 1 row4,190WHERE vbeln = '0082408165'WHERE erdat = '20160616'.
17
Select single returning row
3,600AND POSNR = '000010'.
18
Using Count (*)No record found798
19
Using SELECT SINGLE @abap_true
No record found923Using Count(*)
20
2nd passSELECT count(*) FROM lips BYPASSING BUFFERSELECT COUNT(*) FROM Lips
21
Up to 1 row573WHERE vbeln = '0082408164'BYPASSING BUFFER
22
Select single returning row
486AND POSNR = '000010'.WHERE erdat = '20160614'.
23
Using Count (*)No record found324
24
Using SELECT SINGLE @abap_true
No record found400Using SELECT SINGLE @abap_true
25
SELECT SINGLE @abap_true FROM lipsSELECT SINGLE @abap_true FROM lips
26
No Primary Key, record not found
WHERE vbeln = '008208171'WHERE erdat = '20160613'
27
1st passAND POSNR = '000011'INTO @l_subrc BYPASSING BUFFER.
28
Up to 1 row11,001,328INTO @data(l_subrc) BYPASSING BUFFER.
29
Select single returning row
4,324,123
30
Using Count (*)No record found2,759,485
31
Using SELECT SINGLE @abap_true
No record found1,694,153
32
2nd pass
33
Up to 1 row2,031,862
34
Select single returning row
2,549,218
35
Using Count (*)No record found2,099,516
36
Using SELECT SINGLE @abap_true
No record found1,667,265
37
38
No Primary Key, record found - Record at end of table
Dates used were around 20160616
39
1st pass
40
Up to 1 row824081534,780,520
41
Select single returning row
824081592,599,394
42
Using Count (*)
Record was found
1,633,506
43
Using SELECT SINGLE @abap_true
Record was found
1,622,985
44
2nd pass
45
Up to 1 row824081532,022,015
46
Select single returning row
824081592,043,221
47
Using Count (*)
Record was found
1,633,630
48
Using SELECT SINGLE @abap_true
Record was found
1,665,137
49
50
No Primary Key, record found - Record in middle of table
Dates used where around 20060616
51
1st pass
52
Up to 1 row80509108891,716
53
Select single returning row
80509872710,417
54
Using Count (*)
Record was found
3,392,095
55
Using SELECT SINGLE @abap_true
Record was found
679,612
56
2nd pass
57
Up to 1 row80509108605,200
58
Select single returning row
80509872460,526
59
Using Count (*)
Record was found
1,761,954
60
Using SELECT SINGLE @abap_true
Record was found
311,406
61
62
No Primary Key, record found - Record in begining of table
Dates used where around 19990916
63
1st pass
64
Up to 1 row800029103,921
65
Select single returning row
800031252,028
66
Using Count (*)
Record was found
3,172,584
67
Using SELECT SINGLE @abap_true
Record was found
2,203
68
2nd pass
69
Up to 1 row800029101,898
70
Select single returning row
800031251,824
71
Using Count (*)
Record was found
2,303,027
72
Using SELECT SINGLE @abap_true
Record was found
1,045
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100