summaryrefslogtreecommitdiff
path: root/packages/utils.py
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2012-11-16 15:39:56 -0600
committerDan McGee <dan@archlinux.org>2012-11-16 16:37:52 -0600
commita2cfa7edbbed8edb1ad4d3391c6edb055c13de1b (patch)
treeb703737a5f4afcceeea4691a0d8fb8129569807b /packages/utils.py
parent45d81a9578e846062550335495dbceb82f16a1a0 (diff)
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 'packages/utils.py')
0 files changed, 0 insertions, 0 deletions