commit a03b4c90b6119b5586b576cd52d06bd03feeb9d0
author Quentin Smith <quentin@golang.org> Fri Feb 17 17:26:10 2017 -0500
committer Quentin Smith <quentin@golang.org> Mon Feb 27 20:58:40 2017 +0000
tree ca1d2f8d5694d39b645d3477578af07d14d9178d
parent 9614811b19a139d64323ac66e5868a8d3a8cbbf3

storage/db: optimize query terms matching "upload"

Since the upload ID is part of the primary key, we can avoid using the
RecordLabels table to find matching records. This takes the query
"upload:20170127.22 name:Gzip" from ~0.3s to ~0.04s on our production
database.

Change-Id: Id31624ec1b81f3a7f648c6597392718c56a10edd
Reviewed-on: https://go-review.googlesource.com/37236
Run-TryBot: Quentin Smith <quentin@golang.org>
TryBot-Result: Gobot Gobot <gobot@golang.org>
Reviewed-by: Russ Cox <rsc@golang.org>