sqlx/bind_test.go at master · libsql/sqlx · GitHub

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"
)

funcoldBindType(driverNamestring) int {
switchdriverName {
case"postgres", "pgx", "pq-timeouts", "cloudsqlpostgres", "ql":
returnDOLLAR
case"mysql":
returnQUESTION
case"sqlite3":
returnQUESTION
case"oci8", "ora", "goracle", "godror":
returnNAMED
case"sqlserver":
returnAT
	}
returnUNKNOWN
}

/*
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
*/

funcBenchmarkBindSpeed(b*testing.B) {
testDrivers:= []string{
"postgres", "pgx", "mysql", "sqlite3", "ora", "sqlserver",
	}

b.Run("old", func(b*testing.B) {
b.StopTimer()
varseq []int
fori:=0; i<b.N; i++ {
seq=append(seq, rand.Intn(len(testDrivers)))
 }
b.StartTimer()
fori:=0; i<b.N; i++ {
s:=oldBindType(testDrivers[seq[i]])
ifs==UNKNOWN {
b.Error("unknown driver")
 }
 }

	})

b.Run("new", func(b*testing.B) {
b.StopTimer()
varseq []int
fori:=0; i<b.N; i++ {
seq=append(seq, rand.Intn(len(testDrivers)))
 }
b.StartTimer()
fori:=0; i<b.N; i++ {
s:=BindType(testDrivers[seq[i]])
ifs==UNKNOWN {
b.Error("unknown driver")
 }
 }

	})
}