diff options
| author | Dan McGee <dan@archlinux.org> | 2013-04-13 18:33:17 +0200 |
|---|---|---|
| committer | Dan McGee <dan@archlinux.org> | 2013-04-13 18:41:33 +0200 |
| commit | 2c24ee9100a9e60fec16055d6496caeda3a1d8e2 (patch) | |
| tree | 7d7ac7f0ab84cd22d57545fc408d9f41e9028cfc /HACKING | |
| parent | 06e1e857abfdf7f95661d337ce3c315bd51fb837 (diff) | |
| download | archweb-2c24ee9100a9e60fec16055d6496caeda3a1d8e2.tar.gz archweb-2c24ee9100a9e60fec16055d6496caeda3a1d8e2.tar.xz | |
Calculate average URL delay in the database
Rather than doing this in the Python code and needing 12,000+ rows
returned from the database, we can do it in the database and get fewer
than 300 rows back.
If I recall correctly, the reason this was not done originally was due
to our usage of MySQL and some really bad date math/overflow stuff it
did when the interval between last_sync and check_time were greater than
about a week. Luckily, we have switched to using a more sane database.
Signed-off-by: Dan McGee <dan@archlinux.org>
Diffstat (limited to 'HACKING')
0 files changed, 0 insertions, 0 deletions