#5 Data averaging

[Willem]

It would be great if there was some support for
automatic data-averaging in the database, performed by
RTG.

I am currently RTG as monitoring system for a large ISP
and our database would grow too big if we saved raw
data always. We are going to be averaging the data
somehow, but continuously running scripts through our
multi-GB database is too inefficient for us (too much
overhead).

If necessary, I will build data averaging possibilities
into RTG myself, but I am very curious if any attempts
in this direction have ever been succesful - maybe
there is a version of RTG that supports data averaging,
somewhere.

=================================

For example:

- Possibility to set the amount of days to keep raw
data (300sec interval - i = 300) - eg. 2 days
- Possibility to set the amount of days to keep data
with an interval of i * 12 (thus an hour) - eg. keep 7
days of polling data, averaged per hour
- Possibility to set the amount of days to keep data
with an interval of i * 12 * 24 (thus a day) - eg. keep
31 days of polling data, averaged per day
- Possibility to set the amount of days to keep data
with an interval of i * 12 * 24 * 7 (thus a week) - eg.
keep 365 days of polling data, averaged per week

This would greatly decrease database space used, and
makes graphing systems based on long-term data
TREMENDOUSLY quicker. As said, if necessary I will
implement it myself, but it is a true feature request
of mine!