commit 8018521834b1023662792066dd656e4816ca379b
author Quentin Smith <quentin@golang.org> Fri Feb 17 16:34:12 2017 -0500
committer Quentin Smith <quentin@golang.org> Mon Feb 27 21:03:27 2017 +0000
tree ca794260b0ca7bff81823274532591f162b32c27
parent 5a6afbd2f03d809f5315c389ddf024387a0b61f8

storage/db: optimize /uploads queries without query string

This uses a different query structure for ListUploads when the query
string is empty. On our production database, this reduces the query
time from ~5s to ~0.1s, which drastically improves the performance of
perf.golang.org.

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