1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
data.table outer join benchmark profile

$by.total
                    total.time total.pct self.time self.pct
"system.time"             1.48    100.00      0.00     0.00
"merge"                   1.44     97.30      0.00     0.00
"merge.data.table"        1.44     97.30      0.00     0.00
"outer.join.dt"           1.44     97.30      0.00     0.00
"["                       0.76     51.35      0.00     0.00
"[.data.table"            0.74     50.00      0.10     6.76
"rbind"                   0.42     28.38      0.00     0.00
".rbind.data.table"       0.42     28.38      0.00     0.00
"c"                       0.40     27.03      0.02     1.35
"do.call"                 0.40     27.03      0.00     0.00
"c.factor"                0.38     25.68      0.02     1.35
".Call"                   0.30     20.27      0.30    20.27
"fastorder"               0.28     18.92      0.00     0.00
"sortedmatch"             0.24     16.22      0.00     0.00
"regularorder1"           0.20     13.51      0.20    13.51
"match"                   0.18     12.16      0.16    10.81
"unique"                  0.16     10.81      0.02     1.35
"[[<-.data.frame"         0.14      9.46      0.14     9.46
"[[<-"                    0.14      9.46      0.00     0.00
"setdiff"                 0.14      9.46      0.00     0.00
"FUN"                     0.10      6.76      0.06     4.05
"cbind"                   0.10      6.76      0.00     0.00
"lapply"                  0.10      6.76      0.00     0.00
"unlist"                  0.10      6.76      0.00     0.00
"dim"                     0.08      5.41      0.02     1.35
"sort.int"                0.06      4.05      0.04     2.70
"[["                      0.06      4.05      0.02     1.35
"dim.data.table"          0.06      4.05      0.00     0.00
"key<-"                   0.06      4.05      0.00     0.00
"nrow"                    0.06      4.05      0.00     0.00
"setattr"                 0.06      4.05      0.00     0.00
"setkey"                  0.06      4.05      0.00     0.00
".set_row_names"          0.06      4.05      0.00     0.00
"sort"                    0.06      4.05      0.00     0.00
"sort.default"            0.06      4.05      0.00     0.00
"try"                     0.06      4.05      0.00     0.00
"tryCatch"                0.06      4.05      0.00     0.00
"tryCatchList"            0.06      4.05      0.00     0.00
"tryCatchOne"             0.06      4.05      0.00     0.00
"as.integer"              0.04      2.70      0.04     2.70
"gc"                      0.04      2.70      0.04     2.70
"names"                   0.04      2.70      0.04     2.70
"[[.data.frame"           0.04      2.70      0.02     1.35
"doTryCatch"              0.04      2.70      0.00     0.00
"%in%"                    0.04      2.70      0.00     0.00
"radixorder1"             0.04      2.70      0.00     0.00
"+"                       0.02      1.35      0.02     1.35
"as.list"                 0.02      1.35      0.02     1.35
"formals"                 0.02      1.35      0.02     1.35
"inherits"                0.02      1.35      0.02     1.35

inner join


$by.total
                        total.time total.pct self.time self.pct
"system.time"                 0.78     95.12      0.00     0.00
"inner.join.dt"               0.76     92.68      0.00     0.00
"merge"                       0.76     92.68      0.00     0.00
"merge.data.table"            0.76     92.68      0.00     0.00
"[.data.table"                0.62     75.61      0.04     4.88
"["                           0.62     75.61      0.00     0.00
".Call"                       0.36     43.90      0.36    43.90
"sortedmatch"                 0.30     36.59      0.00     0.00
"[[<-.data.frame"             0.16     19.51      0.16    19.51
"[[<-"                        0.16     19.51      0.00     0.00
"data.table"                  0.06      7.32      0.06     7.32
"sort.int"                    0.06      7.32      0.06     7.32
"cbind"                       0.06      7.32      0.00     0.00
"sort"                        0.06      7.32      0.00     0.00
"sort.default"                0.06      7.32      0.00     0.00
"ls"                          0.04      4.88      0.04     4.88
"apropos"                     0.04      4.88      0.00     0.00
".completeToken"              0.04      4.88      0.00     0.00
"normalCompletions"           0.04      4.88      0.00     0.00
"dim"                         0.02      2.44      0.02     2.44
"gc"                          0.02      2.44      0.02     2.44
"head.default"                0.02      2.44      0.02     2.44
"is.unsorted"                 0.02      2.44      0.02     2.44
"unique"                      0.02      2.44      0.02     2.44
">="                          0.02      2.44      0.00     0.00
"as.numeric_version"          0.02      2.44      0.00     0.00
"head"                        0.02      2.44      0.00     0.00
"integer"                     0.02      2.44      0.00     0.00
"key<-"                       0.02      2.44      0.00     0.00
".make_numeric_version"       0.02      2.44      0.00     0.00
"nrow"                        0.02      2.44      0.00     0.00
"numeric_version"             0.02      2.44      0.00     0.00
"Ops.numeric_version"         0.02      2.44      0.00     0.00
"setattr"                     0.02      2.44      0.00     0.00
"setkey"                      0.02      2.44      0.00     0.00
"settruelength"               0.02      2.44      0.00     0.00

left join

$by.total
                    total.time total.pct self.time self.pct
"system.time"             0.52     96.30      0.00     0.00
"[.data.table"            0.48     88.89      0.08    14.81
"["                       0.48     88.89      0.00     0.00
"left.join.dt"            0.48     88.89      0.00     0.00
".Call"                   0.16     29.63      0.16    29.63
"[[<-.data.frame"         0.16     29.63      0.16    29.63
"[[<-"                    0.16     29.63      0.00     0.00
"sortedmatch"             0.12     22.22      0.00     0.00
"gc"                      0.04      7.41      0.04     7.41
"head"                    0.04      7.41      0.00     0.00
"+"                       0.02      3.70      0.02     3.70
"cumsum"                  0.02      3.70      0.02     3.70
"head.default"            0.02      3.70      0.02     3.70
"ls"                      0.02      3.70      0.02     3.70
"tail.default"            0.02      3.70      0.02     3.70
"apropos"                 0.02      3.70      0.00     0.00
".completeToken"          0.02      3.70      0.00     0.00
"normalCompletions"       0.02      3.70      0.00     0.00
"tail"                    0.02      3.70      0.00     0.00