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
|
package sqlx
import (
"math/rand"
"testing"
)
func oldBindType(driverName string) int {
switch driverName {
case "postgres", "pgx", "pq-timeouts", "cloudsqlpostgres", "ql":
return DOLLAR
case "mysql":
return QUESTION
case "sqlite3":
return QUESTION
case "oci8", "ora", "goracle", "godror":
return NAMED
case "sqlserver":
return AT
}
return UNKNOWN
}
/*
sync.Map implementation:
goos: linux
goarch: amd64
pkg: github.com/jmoiron/sqlx
BenchmarkBindSpeed/old-4 100000000 11.0 ns/op
BenchmarkBindSpeed/new-4 24575726 50.8 ns/op
async.Value map implementation:
goos: linux
goarch: amd64
pkg: github.com/jmoiron/sqlx
BenchmarkBindSpeed/old-4 100000000 11.0 ns/op
BenchmarkBindSpeed/new-4 42535839 27.5 ns/op
*/
func BenchmarkBindSpeed(b *testing.B) {
testDrivers := []string{
"postgres", "pgx", "mysql", "sqlite3", "ora", "sqlserver",
}
b.Run("old", func(b *testing.B) {
b.StopTimer()
var seq []int
for i := 0; i < b.N; i++ {
seq = append(seq, rand.Intn(len(testDrivers)))
}
b.StartTimer()
for i := 0; i < b.N; i++ {
s := oldBindType(testDrivers[seq[i]])
if s == UNKNOWN {
b.Error("unknown driver")
}
}
})
b.Run("new", func(b *testing.B) {
b.StopTimer()
var seq []int
for i := 0; i < b.N; i++ {
seq = append(seq, rand.Intn(len(testDrivers)))
}
b.StartTimer()
for i := 0; i < b.N; i++ {
s := BindType(testDrivers[seq[i]])
if s == UNKNOWN {
b.Error("unknown driver")
}
}
})
}
|
