[rtg] rtg status?

[Adrian Chadd]

On Wed, Jan 07, 2009, john at quonix.net wrote:

> Since the daily/weekly/monthly graph views are sort-of aggregate anyway, 
> we created a second database that generates special "aggregate" data 
> tables which are much smaller - and these tables recycle/remove data 
> points not needed for their scope - so the tables remain small long-term. 
> These tables are updated every hour from cron. Then we tweaked the 
> view.php to look at these smaller tables. End result is the end-user 
> graphs load much faster, but the original raw data tables are still there 
> for admins to run queries against. 

Would you be willing to share this stuff? I'm sure that'd make a great
addition to the codebase.

I'm sure that feature would be quite appreciated by a bunch of RTG users.
(It'd just have to be verified for the three backend db's in use -
mysql, pgsql and oracle.)



Adrian