diff options
author | Dan McGee <dan@archlinux.org> | 2012-11-16 15:39:56 -0600 |
---|---|---|
committer | Dan McGee <dan@archlinux.org> | 2012-11-16 16:37:52 -0600 |
commit | a2cfa7edbbed8edb1ad4d3391c6edb055c13de1b (patch) | |
tree | b703737a5f4afcceeea4691a0d8fb8129569807b /mirrors/fixtures | |
parent | 45d81a9578e846062550335495dbceb82f16a1a0 (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 'mirrors/fixtures')
0 files changed, 0 insertions, 0 deletions