tree ca1d2f8d5694d39b645d3477578af07d14d9178d
parent 9614811b19a139d64323ac66e5868a8d3a8cbbf3
author Quentin Smith <quentin@golang.org> 1487370370 -0500
committer Quentin Smith <quentin@golang.org> 1488229120 +0000

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>