commit 6ce1bbec27433abdb9ea21599765805d38050e91
author Quentin Smith <quentin@golang.org> Tue Jan 17 17:20:07 2017 -0500
committer Quentin Smith <quentin@golang.org> Wed Jan 18 05:25:36 2017 +0000
tree ee3b6443f7a32bf9c0f469e638cb7baf99ae11ef
parent 4515b322c3a6c056dbd72315e870a3aa34725661

storage/db: batch INSERT statements across records

The MySQL protocol requires 1-3 synchronous round-trips for every
INSERT statement; to reduce the overhead, we now batch up 900 label
INSERT statments at a time. This makes a massive difference;
TestQuery previously ran in 108s; with this change, it now runs in 5s.

We were also affected by golang/go#15606; since we now generate a new INSERT
statement for every record, we are sidestepping that issue.

Change-Id: Id7a56c18c0978470542135894a2f2bcf6f7c9dd1
Reviewed-on: https://go-review.googlesource.com/35266
Reviewed-by: Russ Cox <rsc@golang.org>