summaryrefslogtreecommitdiffstats
path: root/public/static/logos/legacy/arch-legacy-aqua-blue.png
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2012-11-16 22:39:56 +0100
committerDan McGee <dan@archlinux.org>2012-11-16 23:37:52 +0100
commita2cfa7edbbed8edb1ad4d3391c6edb055c13de1b (patch)
treeb703737a5f4afcceeea4691a0d8fb8129569807b /public/static/logos/legacy/arch-legacy-aqua-blue.png
parent45d81a9578e846062550335495dbceb82f16a1a0 (diff)
downloadarchweb-a2cfa7edbbed8edb1ad4d3391c6edb055c13de1b.tar.gz
archweb-a2cfa7edbbed8edb1ad4d3391c6edb055c13de1b.tar.xz
Optimize mirror status data fetching
Now that we have as many mirror URLs as we do, we can do a better job fetching and aggregating this data. The prior method resulted in a rather unwieldy query being pushed down to the database with a horrendously long GROUP BY clause. Instead of trying to group by everything at once so we can retrieve mirror URL info at the same time, separate the two queries- one for getting URL performance data, one for the qualitative data. The impetus behind fixing this is the PostgreSQL slow query log in production; this currently shows up the most of any queries we run in the system. Signed-off-by: Dan McGee <dan@archlinux.org>
Diffstat (limited to 'public/static/logos/legacy/arch-legacy-aqua-blue.png')
0 files changed, 0 insertions, 0 deletions