Go鐃叔ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃祝居申鐃緒申弔鐃緒申鐃緒申鐃緒申鐃緒申匹鐃緒申鐃緒申法
Go鐃緒申Python鐃塾よう鐃緒申LL鐃緒申鐃緒申戮鐃夙実刻申速鐃駿わ申速鐃緒申鐃塾でわ申鐃緒申鐃緒申GC鐃緒申鐃緒申鐃緒申速鐃緒申鐃緒け鐃叔はなわ申鐃塾で￥申鐃緒申鐃緒申的鐃緒申GC鐃緒申鐃術フワ申鐃緒申鐃殉ンスわ申与鐃緒申鐃緒申洞鐃緒申鐃緒申腓�鐃緒申鐃淑わ申泙鐃緒申鐃�
鐃殉わ申鐃緒申Java 鐃緒申鐃緒申戮鐃夙￥申鐃緒申鐃緒申鐃緒申屮鐃緒申鐃緒申鐃緒申箸覆匹里鐃緒申鐃緒申鐃緒申鐃祝にヒ￥申鐃竣ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申圓鐃緒申鐃�GC鐃緒申鐃緒申濟鐃緒申屬鐃縦刻申鐃緒申覆蠅�鐃緒申鐃叔わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃叔ヒ￥申鐃竣ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃薯けわ申鐃竣ワ申鐃緒申鐃緒申潺鵐阿鐃緒申鐃緒申笋刻申鐃緒申鐃緒申鐃叔もあ鐃緒申泙鐃緒申鐃�
MySQL 鐃宿ライ鐃出のよう鐃緒申鐃緒申譽わ申筺種申離薀わ申屮鐃緒申鐃緒申鐃緒申隋�鐃緒申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃渋�鐃緒申鐃緒申能鐃竣件申鮠ー鐃祝件申鐃暑こ鐃夙わ申鐃叔わ申鐃淑わ申鐃塾で￥申鐃緒申鐃緒申的鐃緒申鐃熟囲でワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃薯減らす鐃緒申鐃熟をすわ申戮鐃緒申任鐃緒申鐃�
鐃夙わ申鐃緒申鐃緒申鐃夙で￥申鐃緒申鐃緒申竜鐃緒申鐃� 鐃叔紹介しわ申鐃竣レー鐃緒申鐃循ワ申鐃緒申峇鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申砲鐃緒申鐃緒申辰瞳亳鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申傍鐃緒申鐃夙っわ申鐃竣ワ申鐃緒申鐃緒申潺鵐阿砲弔鐃緒申董鐃緒申鐃緒申紂種申縫鵐阿鐃緒申鐃緒申鐃巡コ鐃緒申鐃宿常申離謄鐃緒申縫奪鐃緒申鐃述介しわ申鐃緒申鐃夙思わ申鐃殉わ申鐃緒申
1. 鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申動鐃緒申鐃緒申里鐃緒申鐃�
go-sql-driver/mysql 鐃塾ワ申鐃銃ナに種申鐃緒申鐃緒申鐃緒申鐃緒申襪�鐃宿わ申鐃緒申分鐃緒申鐃緒申覆鐃緒申鐃叔緒申鐃緒申辰鐃緒申里如鐃緒申能鐃熟なわ申戮鐃緒申鐃獣縁申房鐃緒申鐃緒申鐃緒申董鐃緒申鐃緒申竜鐃叔緒申鐃緒申鐃緒申鐃準か鐃宿わ申鐃緒申鐃緒申API鐃緒申鐃淳計はわ申鐃緒申任鐃緒申鐃緒申鐃緒申箸鐃緒申鐃緒申辰鐃緒申鐃熟わ申泙鐃緒申鐃�
2. 鐃駿ワ申鐃緒申沺鐃緒申鐃緒申廛鐃緒申鐃緒申鐃緒申鐃緒申
鐃緒申鐃遵ー鐃祝ングわ申呂鐃緒申鐃緒申鐃祝￥申鐃緒申鐃縮鰹申認鐃術のベワ申鐃緒申沺鐃緒申鐃緒申廛鐃緒申鐃緒申鐃緒申鐃書きまわ申鐃緒申 鐃銃ワ申鐃夙わ申同鐃緒申鐃緒申 _test.go 鐃夙わ申鐃緒申名鐃緒申鐃叔緒申鐃緒申鐃春ワ申鐃緒申鐃緒申法鐃� BenchmarkXxxx(b *testing.B) 鐃夙わ申鐃緒申鐃舜随申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申 b.ReportAllocs() 鐃緒申討鐃叔わ申鐃緒申鐃夙ワ申鐃緒申鐃緒申鐃緒申鐃夙駕申鐃緒申鐃緒申測鐃緒申鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申戰鐃緒申鐃殉￥申鐃緒申鐃竣ワ申鐃緒申鐃緒申鐃熟種申鐃塾よう鐃淑わ申里任鐃緒申鐃� database/sql 鐃緒申鐃醇ー鐃緒申鐃緒申鐃緒申鐃熟わ申鐃緒申鐃粛わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃銃わ申鐃緒申鐃塾で￥申鐃宿ライ鐃緒申側鐃緒申鐃熟わ申鐃緒申鐃緒申佑鐃� int64, float64, bool, time.Time, []byte, string 鐃緒申6鐃縦の件申鐃緒申鐃緒申鐃祝なわ申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃�6鐃縦わ申鐃緒申鐃緒申鐃粛わ申1鐃縦わ申鐃緒申鐃術意わ申鐃銃￥申鐃竣レー鐃緒申鐃循ワ申鐃緒申峇鐃緒申鐃渋行わ申鐃銃わ申鐃殉わ申鐃緒申
func BenchmarkInterpolation(b *testing.B) {
mc := &mysqlConn{
cfg: &config{
interpolateParams: true,
loc: time.UTC,
},
maxPacketAllowed: maxPacketSize,
maxWriteSize: maxPacketSize - 1,
}
args := []driver.Value{
int64(42424242),
float64(math.Pi),
false,
time.Unix(1423411542, 807015000),
[]byte("bytes containing special chars ' \" \a \x00"),
"string containing special chars ' \" \a \x00",
}
q := "SELECT ?, ?, ?, ?, ?, ?"
b.ReportAllocs()
b.ResetTimer()
for i := 0; i < b.N; i++ {
_, err := mc.interpolateParams(q, args)
if err != nil {
b.Fatal(err)
}
}
}
鐃渋行わ申鐃緒申砲麓鐃緒申里茲�鐃淑ワ申鐃殉ワ申匹鐃渋行わ申鐃殉わ申鐃緒申
$ go test -bench=BenchmarkInterpolation PASS BenchmarkInterpolation 300000 3887 ns/op 1144 B/op 15 allocs/op ok github.com/go-sql-driver/mysql 2.386s
3. 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鵑�居申鐃緒申鐃獣てわ申鐃緒申鐃緒申鐃縦器申戮鐃�
GODEBUG=allocfreetrace=1 鐃夙わ申鐃緒申鐃縦駈申鐃術随申鐃緒申鐃緒申鐃所す鐃緒申函鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申箸鐃緒申鐃緒申鐃緒申辰鐃緒申鐃緒申離鐃緒申鐃緒申奪鐃緒申肇譟種申鐃緒申鮓�るこ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 (鐃宿ワ申鐃緒申鐃緒申鐃�)
鐃緒申鐃緒申鐃叔￥申鐃駿ワ申鐃緒申沺鐃緒申鐃緒申廛鐃緒申鐃緒申鐃緒申離襦種申廚鐃緒申鐃夙わ申鐃緒申鐃緒申孫圓鐃緒申訃�鐃緒申鐃淑プワ申鐃緒申鐃緒申鐃緒申鐃術意わ申鐃緒申鐃緒申鐃塾でわ申鐃緒申鐃緒申鐃緒申鐃緒申鐃術意わ申鐃銃わ申鐃緒申里肋鐃淑醐申鐃緒申鐃緒申鐃熟まわ申名鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃淑ので￥申 main 鐃術ッワ申鐃緒申鐃緒申鐃緒申鐃緒申直鐃旬呼び出わ申鐃緒申鐃夙はでわ申鐃殉わ申鐃緒申 mysql 鐃術ッワ申鐃緒申鐃緒申鐃祝ワ申鐃淳ットに含わ申覆鐃緒申鐃緒申鐃緒申鐃緒申侫鐃緒申鐃緒申鐃緒申鐃宿加わ申鐃銃わ申鐃緒申鐃緒申鐃緒申討喀个鐃緒申鐃緒申匹鐃緒申里任鐃緒申鐃緒申鐃緒申鐃緒申鐃熟ベワ申鐃緒申沺鐃緒申鐃緒申廛鐃緒申鐃緒申鐃緒申鐃縦常申鐃緒申鐃緒申僂鐃緒申襪鰹申箸砲鐃緒申泙鐃緒申鐃緒申鐃�
GODEBUG 鐃緒申鐃緒申鐃所し鐃緒申鐃殉わ申 go test 鐃緒申孫圓鐃緒申鐃夙ノワ申鐃緒申鐃緒申多鐃緒申鐃緒申鐃緒申里如鐃緒申鐃緒申 go test -c 鐃緒申箸辰鐃� mysql.test 鐃夙わ申鐃緒申鐃渋行フワ申鐃緒申鐃緒申鐃緒申蝓�鐃緒申鐃緒申鐃渋行わ申鐃殉わ申鐃緒申鐃緒申鐃塾際￥申鐃緒申鐃竣ワ申鐃緒申鐃緒申 go test 鐃緒申鐃熟わ申鐃緒申鐃竣ワ申鐃緒申鐃緒申 test. 鐃夙わ申鐃緒申 prefix 鐃緒申弔鐃緒申襪鰹申箸砲覆鐃殉わ申鐃緒申
$ go test -c $ GODEBUG=allocfreetrace=1 ./mysql.test -test.run=none -test.bench=BenchmarkInter -test.benchtime=10ms 2>trace.log PASS BenchmarkInterpolation 5000 4095 ns/op 1144 B/op 15 allocs/op
鐃緒申鐃緒申鐃緒申任蓮鐃� -test.run 鐃祝どのテワ申鐃夙にわ申泪奪鐃緒申鐃緒申覆鐃重�鐃緒申鐃緒申名鐃緒申 none 鐃緒申鐃緒申蠅件申謄戰鐃緒申鐃殉￥申鐃緒申鐃淑鰹申鐃塾テワ申鐃夙わ申鐃渋行わ申鐃緒申襪鰹申箸鐃緒申匹鐃緒申鐃� -test.bench 鐃緒申鐃緒申的鐃淑鰹申鐃塾ベワ申鐃緒申沺鐃緒申鐃緒申愎鐃緒申亮孫圓鐃緒申淹澆鐃緒申鐃� -test.benchtime=10ms 鐃叔デフワ申鐃緒申鐃�1鐃獣のベワ申鐃緒申沺鐃緒申鐃緒申鐃緒申屬鐃獣誌申鐃緒申鐃緒申討鐃緒申泙鐃緒申鐃宿醐申爛�鐃初ー鐃緒申鐃熟にワ申鐃緒申鐃緒申鐃緒申鐃夙のワ申鐃緒申鐃獣ワ申鐃夙レー鐃緒申鐃緒申鐃緒申鐃熟わ申鐃緒申討鐃緒申鐃塾で￥申鐃緒申鐃緒申鐃� trace.log 鐃祝緒申鐃熟わ申鐃銃わ申鐃殉わ申鐃緒申
鐃緒申的鐃塾関随申鐃叔わ申鐃緒申 interpolateParams 鐃緒申探鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃夙種申鐃塾よう鐃淑ワ申鐃緒申鐃獣ワ申鐃夙レー鐃緒申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申
tracealloc(0xc2080100e0, 0x70, string) goroutine 5 [running]: runtime.mallocgc(0x70, 0x22e4e0, 0x0, 0x2) /usr/local/Cellar/go/1.4.1/libexec/src/runtime/malloc.go:327 +0x32a fp=0xc20802ea60 sp=0xc20802e9b0 runtime.newarray(0x22e4e0, 0x7, 0x15c5e) /usr/local/Cellar/go/1.4.1/libexec/src/runtime/malloc.go:365 +0xc1 fp=0xc20802ea98 sp=0xc20802ea60 runtime.makeslice(0x2229c0, 0x7, 0x7, 0x0, 0x0, 0x0) /usr/local/Cellar/go/1.4.1/libexec/src/runtime/slice.go:32 +0x15c fp=0xc20802eae0 sp=0xc20802ea98 strings.genSplit(0x30c190, 0x17, 0x2e1f10, 0x1, 0x0, 0x7, 0x0, 0x0, 0x0) /usr/local/Cellar/go/1.4.1/libexec/src/strings/strings.go:287 +0x14d fp=0xc20802eb60 sp=0xc20802eae0 strings.Split(0x30c190, 0x17, 0x2e1f10, 0x1, 0x0, 0x0, 0x0) /usr/local/Cellar/go/1.4.1/libexec/src/strings/strings.go:325 +0x76 fp=0xc20802ebb0 sp=0xc20802eb60 github.com/go-sql-driver/mysql.(*mysqlConn).interpolateParams(0xc20802eed0, 0x30c190, 0x17, 0xc20802ee70, 0x6, 0x6, 0x0, 0x0, 0x0, 0x0) /Users/inada-n/go1.4/src/github.com/go-sql-driver/mysql/connection.go:180 +0x86 fp=0xc20802ed38 sp=0xc20802ebb0 github.com/go-sql-driver/mysql.BenchmarkInterpolation(0xc20806a400) /Users/inada-n/go1.4/src/github.com/go-sql-driver/mysql/benchmark_test.go:240 +0x437 fp=0xc20802ef58 sp=0xc20802ed38 testing.(*B).runN(0xc20806a400, 0x1) /usr/local/Cellar/go/1.4.1/libexec/src/testing/benchmark.go:124 +0x95 fp=0xc20802ef68 sp=0xc20802ef58 testing.(*B).launch(0xc20806a400) /usr/local/Cellar/go/1.4.1/libexec/src/testing/benchmark.go:199 +0x78 fp=0xc20802efd8 sp=0xc20802ef68 runtime.goexit() /usr/local/Cellar/go/1.4.1/libexec/src/runtime/asm_amd64.s:2232 +0x1 fp=0xc20802efe0 sp=0xc20802efd8 created by testing.(*B).run /usr/local/Cellar/go/1.4.1/libexec/src/testing/benchmark.go:179 +0x3e ...(続鐃緒申)
鐃緒申鐃塾ワ申鐃緒申鐃獣ワ申鐃夙レー鐃緒申鐃緒申 interpolateParams() 鐃緒申鐃緒申 strings.Split() 鐃緒申討喀个鐃緒申討鐃緒申鐃緒申鐃淑�鐃叔ワ申鐃緒申鐃緒申鐃緒申鐃夙わ申発鐃緒申鐃緒申鐃銃わ申鐃暑こ鐃夙わ申分鐃緒申鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃宿のフワ申鐃緒申鐃緒申名鐃夙行随申鐃緒申颪�わ申討鐃緒申鐃塾で￥申鐃緒申単鐃祝鰹申鐃緒申鐃緒申分鐃緒申鐃緒申鐃緒申任鐃緒申泙鐃緒申鐃�
func (mc *mysqlConn) interpolateParams(query string, args []driver.Value) (string, error) {
chunks := strings.Split(query, "?")
if len(chunks) != len(args)+1 {
return "", driver.ErrSkip
}
余鐃縮でわ申鐃緒申鐃緒申鐃緒申鐃緒申鐃獣ワ申鐃夙レー鐃緒申鐃塾よう鐃淑「わ申鐃緒申鐃緒申鐃緒申留竸鐃緒申鐃緒申廚鮓�わ申鐃緒申鐃祝￥申反鐃緒申的鐃緒申無鐃暑し鐃銃ワ申鐃初ー鐃緒申奪鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鬟灰團擇鐃緒申銅鐃緒申笋刻申鐃粛わ申茲�鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申鐃塾わ申鐃緒申鐃宿わ申里傍鐃緒申呂鐃緒申鐃緒申襪�鐃盾し鐃緒申泙鐃緒申鵑�￥申鐃緒申鐃緒申鐃獣ワ申鐃夙レー鐃緒申鐃熟わ申鐃塾醐申鐃緒申筌�鐃竣リケ鐃緒申鐃緒申鐃緒申鐃薯深わ申鐃塾わ申鐃緒申廚兵蠅�鐃緒申鐃緒申覆里如鐃緒申妊丱奪鐃緒申鐃緒申鐃緒申鐃遵ー鐃祝ングわ申鐃緒申箸鐃緒申覆匹呂鐃緒申辰鐃緒申鐃夙醐申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃順う鐃緒申
4. 鐃緒申鐃遵ー鐃祝ワ申
鐃緒申鐃緒申能鐃緒申鐃緒申鐃緒申鐃獣種申任鐃緒申鐃緒申鐃緒申箸鐃�1鐃緒申1鐃縦駕申鐃緒申鐃緒申鐃淑わ申鐃緒申埜鐃緒申未鐃緒申認鐃緒申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申鐃夙りあ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申屬離戰鐃緒申鐃殉￥申鐃緒申鐃緒申未鐃縦わ申鐃銃わ申鐃緒申鐃殉わ申鐃順う鐃緒申
$ go test -bench=BenchmarkInterpolation | tee old.txt PASS BenchmarkInterpolation 500000 3942 ns/op 1144 B/op 15 allocs/op ok github.com/go-sql-driver/mysql 3.219s
4.1. 文鐃緒申鐃緒申連鐃暑か鐃緒申 []byte 鐃舜わ申 append 鐃緒申
鐃叔緒申亮鐃緒申鐃緒申蓮鐃緒申鐃緒申鐃緒申鐃淑醐申鐃緒申鐃緒申 ? 鐃緒申分鐃巡し鐃銃￥申 parts []string 鐃緒申分鐃巡さ鐃曙た鐃銃ワ申鐃緒申鐃緒申文鐃緒申鐃緒申函鐃緒申僖鐃潤ー鐃緒申鐃緒申文鐃緒申鐃藷化わ申鐃緒申鐃緒申里鐃緒申澆乏鐃叔種申鐃� ("SELECT SLEEP(0)", 42 鐃淑わ申 []string{"SELECT SLEEP(", "42", ")"})鐃緒申鐃叔醐申鐃� strings.Join(parts, "") 鐃叔件申腓刻申鐃夙わ申鐃緒申鐃緒申LL鐃叔書くよう鐃淑ワ申鐃緒申鐃宿でわ申鐃緒申鐃緒申
Go 鐃緒申文鐃緒申鐃緒申鐃� immutable 鐃淑ので￥申鐃緒申鐃緒申鐃緒申文鐃緒申鐃緒申鬚燭鐃緒申鐃緒申鐃縦わ申鐃暑こ鐃緒申鐃緒申鐃緒申鐃叔はワ申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申鐃緒申里鐃緒申鬚韻鐃緒申泙鐃緒申鵝�わ申鐃緒申鐃叔￥申鐃叔緒申鐃� []byte 鐃塾バッフワ申鐃緒申鐃緒申櫃鐃緒申討鐃緒申鐃緒申鐃緒申謬鐃緒申鐃緒申討鐃緒申鐃緒申茲�鐃祝わ申鐃殉わ申鐃緒申鐃緒申
鐃出ッフワ申鐃緒申鐃緒申鐃縮わ申鐃緒申縫鐃緒申鐃緒申鐃淑醐申鐃緒申鐃夙各パワ申瓠種申鐃緒申鐃緒申薐居申鐃緒申鐃緒申導鐃緒申櫃鐃緒申襪鰹申箸如鐃緒申螢�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃薯けまわ申鐃緒申鐃緒申鐃緒申鐃緒申多鐃緒申鐃� strconv.AppendInt() 鐃夙わ申鐃緒申鐃緒申 []byte 鐃緒申鐃宿居申鐃緒申鐃縦わ申文鐃緒申鐃藷化わ申鐃緒申愎鐃緒申鐃宿醐申鐃初イ鐃瞬ワ申鐃緒申鐃術意わ申鐃緒申討鐃緒申鐃塾でわ申鐃緒申鐃夙わ申鐃殉わ申鐃緒申鐃緒申鐃緒申納鐃緒申里茲�鐃淑ワ申鐃緒申鐃宿になわ申泙鐃緒申鐃緒申鐃�
buf := make([]byte, 0, estimated)
argPos := 0
// Go 1.5 will optimize range([]byte(string)) to skip allocation.
for _, c := range []byte(query) {
if c != '?' {
buf = append(buf, c)
continue
}
arg := args[argPos]
argPos++
if arg == nil {
buf = append(buf, []byte("NULL")...)
continue
}
switch v := arg.(type) {
case int64:
buf = strconv.AppendInt(buf, v, 10)
4.2. benchcmp
鐃緒申鐃緒申念鐃獣駈申鐃緒申未鐃緒申認鐃緒申鐃殉わ申鐃緒申鐃緒申鐃塾際￥申 benchcmp 鐃夙わ申鐃緒申鐃縦￥申鐃緒申鐃夙っわ申鐃緒申咾鐃緒申鐃緒申鐃緒申鐃薯コミットワ申鐃緒申鐃祝含わ申鐃緒申 Go 鐃塾ワ申鐃淳ッワ申鐃淳わ申鐃緒申鐃叔ワ申鐃緒申鐃緒申任鐃緒申鐃�
$ go get -u golang.org/x/tools/cmd/benchcmp $ go test -bench=BenchmarkInterpolation > new.txt $ benchcmp old.txt new.txt benchmark old ns/op new ns/op delta BenchmarkInterpolation 3942 2573 -34.73% benchmark old allocs new allocs delta BenchmarkInterpolation 15 6 -60.00% benchmark old bytes new bytes delta BenchmarkInterpolation 1144 560 -51.05%
鐃緒申鐃緒申鐃緒申鐃緒申鐃夙駕申鐃緒申鐃� 15 鐃緒申鐃緒申 6 鐃祝醐申鐃獣てわ申鐃緒申里鐃淑�鐃緒申鐃緒申泙鐃緒申鐃緒申孫鐃渋�鐃駿わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申忘鏝削申任鐃緒申討鐃緒申泙鐃緒申諭鐃�
4.3. Time.Format() 鐃緒申鐃薯けわ申
int64 鐃緒申 float64 鐃緒申 strconv.AppendInt() 鐃緒申 strconv.AppendFloat() 鐃叔わ申鐃曙ぞ鐃緒申 []byte 鐃緒申鐃宿居申鐃緒申鐃暑こ鐃夙わ申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃叔逸申覆鐃緒申鐃� time.Time 鐃祝はわ申鐃塾よう鐃淑メソ鐃獣ドわ申鐃緒申鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃叔￥申鐃駿ッワ申鐃駿ワ申鐃淑ワ申鐃緒申鐃宿わ申文鐃緒申鐃緒申表鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�
before:
case time.Time:
if v.IsZero() {
buf = append(buf, []byte("'0000-00-00'")...)
} else {
fmt := "'2006-01-02 15:04:05.999999'"
if v.Nanosecond() == 0 {
fmt = "'2006-01-02 15:04:05'"
}
s := v.In(mc.cfg.loc).Format(fmt)
buf = append(buf, []byte(s)...)
}
after:
case time.Time:
if v.IsZero() {
buf = append(buf, "'0000-00-00'"...)
} else {
v := v.In(mc.cfg.loc)
v = v.Add(time.Nanosecond * 500) // To round under microsecond
year := v.Year()
year100 := year / 100
year1 := year % 100
month := v.Month()
day := v.Day()
hour := v.Hour()
minute := v.Minute()
second := v.Second()
micro := v.Nanosecond() / 1000
buf = append(buf, []byte{
'\'',
digits10[year100], digits01[year100],
digits10[year1], digits01[year1],
'-',
digits10[month], digits01[month],
'-',
digits10[day], digits01[day],
' ',
digits10[hour], digits01[hour],
':',
digits10[minute], digits01[minute],
':',
digits10[second], digits01[second],
}...)
if micro != 0 {
micro10000 := micro / 10000
micro100 := micro / 100 % 100
micro1 := micro % 100
buf = append(buf, []byte{
'.',
digits10[micro10000], digits01[micro10000],
digits10[micro100], digits01[micro100],
digits10[micro1], digits01[micro1],
}...)
}
buf = append(buf, '\'')
}
after 鐃熟最緒申鐃叔のワ申鐃緒申鐃宿で￥申鐃緒申鐃遵ー鐃祝ング以鰹申鐃祝マワ申鐃緒申鐃緒申鐃緒申鐃緒申分鐃緒申0鐃淑わ申鐃塾�鐃緒申鐃緒申覆匹硫鐃緒申鐃緒申鐃緒申鐃緒申辰討鐃緒申泙鐃緒申鐃�
digits10, digits01 鐃熟緒申鐃緒申鐃薯減らす鐃緒申鐃緒申鐃� 0~99 鐃緒申10鐃塾位わ申1鐃塾位わ申文鐃緒申鐃緒申鐃渋べわ申鐃緒申里任鐃緒申鐃緒申鐃緒申鐃熟削申鐃緒申鐃術意わ申鐃緒申鐃緒申里任呂覆鐃緒申憧鐃緒申鐃� mysql 鐃宿ライ鐃出わ申他鐃塾箇緒申鐃緒申鐃緒申僂鐃緒申鐃銃わ申鐃緒申鐃緒申適鐃緒申鐃緒申適鐃術わ申鐃殉わ申鐃緒申鐃緒申
鐃緒申鐃緒申妊鐃緒申鐃緒申鐃緒申鐃緒申箸鐃�2鐃縦醐申鐃初せ鐃殉わ申鐃緒申鐃緒申
benchmark old allocs new allocs delta
BenchmarkInterpolation 6 4 -33.33%
4.4. 文鐃緒申鐃緒申鐃緒申个鐃緒申鐃� range 鐃緒申箸鐃淑わ申
Go 鐃叔ルー鐃竣わ申箸鐃緒申箸鐃緒申鐃緒申匹鐃� range 鐃緒申文鐃緒申箸鐃緒申里任鐃緒申鐃緒申鐃� string 鐃緒申鐃緒申 s 鐃緒申鐃出わ申鐃緒申 for i, c := range s { 鐃夙わ申鐃緒申函鐃緒申丱鐃緒申鐃獣縁申未任呂覆鐃� unicode 鐃緒申 code point 単鐃縮でルー鐃竣わ申鐃銃わ申鐃殉わ申鐃殉わ申鐃緒申
for i, c := range([]byte(s)) { 鐃塾よう鐃緒申 []byte 鐃祝ワ申鐃純ス鐃夙わ申鐃銃ルー鐃竣わ申鐃銃わ申鐃緒申鐃塾でわ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申 string 鐃緒申鐃緒申 []byte 鐃舜わ申鐃術器申鐃叔ワ申鐃緒申鐃緒申鐃緒申鐃夙とワ申鐃峻￥申鐃緒申鐃渋行わ申鐃緒申討鐃緒申泙鐃緒申泙鐃緒申鐃� (Go 1.5 鐃叔は削申適鐃緒申鐃緒申鐃緒申泙鐃�)
鐃緒申鐃緒申鐃叔￥申鐃緒申鐃緒申鐃� C 鐃緒申鐃緒申鐃緒申鐃緒申 for 文鐃祝緒申直鐃緒申鐃殉わ申鐃緒申
@@ -210,8 +210,8 @@ func (mc *mysqlConn) interpolateParams(query string, args []driver.Value) (strin
buf := make([]byte, 0, estimated)
argPos := 0
- // Go 1.5 will optimize range([]byte(string)) to skip allocation.
- for _, c := range []byte(query) {
+ for i := 0; i < len(query); i++ {
+ c := query[i]
if c != '?' {
鐃緒申鐃緒申任發�1鐃縦ワ申鐃緒申鐃緒申鐃緒申鐃夙を減らす鐃緒申鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申鐃緒申
benchmark old allocs new allocs delta
BenchmarkInterpolation 4 3 -25.00%
4.5. []byte 鐃緒申 string 鐃緒申直鐃緒申 append 鐃緒申鐃緒申
Go 鐃緒申 append 鐃祝は￥申 []T 鐃緒申鐃塾ワ申鐃初イ鐃緒申 ts 鐃緒申 T 鐃緒申鐃緒申鐃緒申鐃緒申 t 鐃緒申1鐃緒申鐃宿加わ申鐃緒申 ts = append(ts, t) 鐃夙￥申鐃縮わ申 []T 鐃緒申鐃塾ワ申鐃初イ鐃緒申 ts2 鐃緒申鐃順す鐃緒申 ts = append(ts, ts2...) 鐃緒申2鐃縦の使わ申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃緒申 []byte 鐃緒申 string 鐃緒申鐃宿居申鐃緒申鐃緒申鐃緒申砲弔鐃緒申討蓮鐃� string 鐃緒申 []byte 鐃緒申鐃叔わ申鐃暑か鐃塾よう鐃緒申直鐃緒申 append 鐃緒申鐃緒申鐃術わ申鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 buff = append(buff, s...)
鐃緒申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃薯けるた鐃緒申鐃� 1 鐃出ワ申鐃夙わ申鐃緒申 append 鐃緒申鐃銃わ申鐃緒申鐃緒申分鐃緒申鐃緒申匹鐃緒申鐃緒申蝓∧醐申鐃緒申鐃緒申謄鐃緒申鬟�ャス鐃夙わ申鐃淑わ申鐃緒申 append 鐃緒申鐃銃わ申鐃緒申鐃緒申分(鐃緒申適鐃緒申鐃緒申鐃緒申鐃粛常申廚淵鐃緒申鐃緒申鐃緒申鐃緒申箸肇鐃緒申圈鐃緒申鐃夙�鐃緒申鐃緒申鐃淑わ申)鐃緒申雰鐃祝わ申鐃緒申鐃緒申鐃緒申任鐃緒申泙鐃緒申鐃緒申鐃�
@@ -210,17 +210,19 @@ func (mc *mysqlConn) interpolateParams(query string, args []driver.Value) (strin
argPos := 0
for i := 0; i < len(query); i++ {
- c := query[i]
- if c != '?' {
- buf = append(buf, c)
- continue
+ q := strings.IndexByte(query[i:], '?')
+ if q == -1 {
+ buf = append(buf, query[i:]...)
+ break
}
+ buf = append(buf, query[i:i+q]...)
+ i += q
arg := args[argPos]
argPos++
if arg == nil {
- buf = append(buf, []byte("NULL")...)
+ buf = append(buf, "NULL"...)
continue
}
鐃緒申鐃緒申呂鐃緒申鐃叔ワ申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃薯けわ申鐃緒申鐃緒申分鐃緒申無鐃緒申鐃獣わ申鐃叔わ申鐃緒申鐃緒申 []byte 鐃緒申 append 鐃緒申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃宿わ申颪�とわ申鐃祝覚わ申鐃銃わ申鐃緒申鐃緒申鐃緒申 Tips 鐃叔わ申鐃緒申鐃緒申
4.6. []bytes 鐃術の関随申鐃緒申 string 鐃術の関随申鐃緒申鐃縮わ申鐃術意わ申鐃緒申
[]byte 鐃緒申鐃塾逸申鐃緒申鐃緒申 string 鐃緒申鐃塾逸申鐃緒申鐃緒申両鐃緒申同鐃緒申鐃処う鐃祝ワ申鐃緒申鐃緒申鐃夙￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃竣わ申鐃殉わ申鐃緒申
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申念鐃淑わ申鐃緒申 Go 鐃緒申 []byte 鐃緒申 string 鐃塾間わ申鐃術器申鐃叔ワ申鐃緒申鐃緒申鐃緒申鐃夙￥申鐃緒申鐃峻￥申鐃緒申発鐃緒申鐃緒申鐃銃わ申鐃殉わ申鐃殉わ申鐃緒申
鐃緒申適鐃緒申鐃叔緒申鐃庶さ鐃緒申鐃塾わ申 buf = append(buf, []byte("NULL")...) 鐃塾よう鐃淑ワ申鐃緒申廛鐃淑ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃叔￥申 string 鐃緒申鐃緒申鐃緒申房鐃緒申愎鐃緒申鐃� []byte 鐃緒申 string(bs) 鐃叔ワ申鐃純ス鐃夙わ申鐃緒申鐃熟わ申鐃緒申鐃巡そ鐃塾逆のワ申鐃緒申鐃緒申鐃叔は醐申鐃淳わ申 Go 鐃叔は削申適鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃叔￥申鐃緒申鐃緒申同鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃竣緒申鐃緒申鐃緒申圓鐃緒申愎鐃緒申鐃� []byte 鐃緒申鐃緒申鐃緒申房鐃緒申弌鐃緒申鐃緒申鐃緒申鐃� string 鐃緒申鐃緒申鐃緒申房鐃緒申弌鐃緒申鐃緒申鐃緒申鐃�2鐃緒申鐃術意わ申鐃殉わ申鐃緒申
鐃緒申鐃緒申謄襦種申鐃緒申鐃緒申 switch 鐃緒申鐃緒申鐃叔も共鐃縮駕申鐃叔わ申鐃淑わ申鐃緒申鐃夙思わ申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申薀わ申鐃重醐申鐃緒申鐃峻わ申鐃緒申鐃緒申鐃緒申鐃粛となわ申鐃順き鐃緒申鐃緒申超鐃緒申鐃銃わ申鐃殉わ申鐃処う鐃緒申鐃緒申能鐃緒申鐃緒申鐃緒申討鐃緒申泙辰鐃緒申里如鐃緒申悗疋鐃緒申團擇鐃�2鐃縦の関随申鐃緒申鐃術意わ申鐃暑こ鐃夙になわ申泙鐃緒申鐃緒申鐃�
鐃緒申鐃緒申麓孫圓鐃緒申鐃駿わ申鐃緒申鐃渋っわ申鐃塾でわ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申文鐃緒申鐃緒申鐃緒申鐃駿て￥申鐃術ワ申瓠種申鐃緒申鐃緒申呂鐃緒申鐃緒申文鐃緒申鐃藷／バワ申鐃緒申鐃緒申鐃� BLOB 鐃緒申 TEXT 鐃緒申鐃緒申鐃順き鐃淑デ￥申鐃緒申鐃叔わ申鐃緒申鐃叔緒申鐃緒申鐃緒申鐃緒申鐃塾で￥申速鐃駿￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃夙駈申鐃緒申鐃重駈申鐃緒申鐃淑わ申鐃緒申鐃夙にわ申鐃殉わ申鐃緒申鐃緒申
鐃緒申鐃峻ペワ申鐃緒申鐃宿はわ申鐃緒申鐃緒申鐃緒申鐃銃ナワ申鐃緒申鐃祝逸申鐃銃駈申鐃緒申擇椶鐃緒申里如鐃緒申鐃緒申鐃熟最醐申亮鐃緒申覆任鐃緒申鐃緒申鐃緒申鐃緒申 Go 鐃塾バ￥申鐃緒申鐃緒申鐃叔駕申鐃初か鐃塾駕申鐃緒申鐃緒申覆鐃緒申儖佞鐃緒申鐃暑こ鐃夙わ申鐃緒申圓鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申如鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申伐鐃緒申鐃緒申2鐃縦にまで醐申鐃緒申泙鐃緒申鐃緒申鐃�
benchmark old ns/op new ns/op delta
BenchmarkInterpolation 2463 2118 -14.01%
benchmark old allocs new allocs delta
BenchmarkInterpolation 3 2 -33.33%
benchmark old bytes new bytes delta
BenchmarkInterpolation 496 448 -9.68%
4.7. 鐃緒申鐃緒申鐃緒申鐃出ッフワ申鐃塾削申鐃緒申鐃緒申
鐃叔醐申忙弔辰鐃�2鐃縦のワ申鐃緒申鐃緒申鐃緒申鐃夙は￥申鐃叔緒申縫丱奪侫鐃緒申鐃緒申儖佞鐃緒申鐃緒申鐃淑�鐃夙￥申鐃叔醐申鐃� MySQL 鐃祝ワ申鐃殉ワ申匹鐃緒申蠅駕申鐃舜随申鐃緒申鐃熟わ申文鐃緒申鐃緒申鐃緒申襪随申鐃祝バッフワ申鐃緒申 string 鐃祝ワ申鐃純ス鐃夙わ申鐃緒申2鐃春緒申任鐃緒申鐃�
MySQL 鐃祝ワ申鐃殉ワ申匹鐃緒申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申鐃術わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃術のバッフワ申鐃祝￥申鐃術ワ申鐃獣トヘッワ申鐃緒申鐃緒申分鐃緒申鐃緒申鐃緒申鐃縦常申椒鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃暑こ鐃夙で最醐申鐃�2鐃縦のワ申鐃緒申鐃緒申鐃緒申鐃夙わ申辰鐃緒申鐃緒申箸鐃緒申任鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申存鐃塾ワ申鐃殉ワ申匹鐃緒申鐃緒申鐃緒申鐃淑�鐃緒申鐃淳計わ申鐃緒申鐃緒申討鐃緒申泙鐃緒申里函鐃緒申謄鐃緒申箸鐃緒申鐃緒申砲鐃緒申鐃緒申覆鐃塾で￥申直鐃旬パワ申鐃獣トわ申鐃獣わ申鐃緒申鐃緒申里麓鐃緒申鼎鐃緒申討鐃緒申鐃緒申董鐃緒申鐃緒申鐃緒申僂離丱奪侫鐃緒申鐃�interpolate鐃祝使わ申鐃緒申鐃緒申鐃祝わ申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申僖鐃緒申奪箸魯鐃緒申鐃緒申鐃緒申4鐃出ワ申鐃夙のヘッワ申鐃緒申鐃春わ申鐃緒申鐃緒申里覆里如鐃緒申鐃緒申鐃緒申鐃重�鐃祝わ申鐃緒申鐃緒申僂鐃緒申鐃塾にぴっわ申鐃緒申任鐃緒申鐃�
benchmark old ns/op new ns/op delta
BenchmarkInterpolation 1900 1403 -26.16%
benchmark old allocs new allocs delta
BenchmarkInterpolation 2 1 -50.00%
benchmark old bytes new bytes delta
BenchmarkInterpolation 448 160 -64.29%
鐃殉とわ申
鐃緒申鐃緒申鐃緒申鐃緒申鐃夙箇緒申鐃緒申鐃緒申蠅刻申鐃緒申鐃祝￥申筺�鐃緒申鐃淑醐申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申紂種申縫鵐阿鐃緒申鐃楯に覚わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃叔ワ申鐃藷グ常申鐃� Tips 鐃緒申匆陲靴泙鐃緒申鐃緒申鐃�
@methane
