[c-nsp] rtg

[Shaun]

My performance problems don't seem to be with rtgpoll, least I don't think
so.  My problem is when viewing a graph for say a month's worth of traffic,
this takes several seconds to generate, and from what I can tell the sql
query pulling the data is what's taking most of the time.  Generating one
graph in a few seconds isn't a huge deal, but when trying to view a daily
traffic for a 24 port switch this can take forever and a few seconds per
graph starts to take even longer...  I'm still using 0.7.4 package they
provided, not the cvs.  I've thought about switching to 0.8 but it sounds
like that ver will be broken.

Right now I'm polling about 12 devices and 576 ports.  Server is a Dual
Xeon, 6GB ram, raid5 U320 SCSI...

~Shaun

-----Original Message-----
From: bill fumerola [mailto:billf at mu.org] 
Sent: Wednesday, February 28, 2007 7:42 AM
To: Shaun
Cc: cisco-nsp at puck.nether.net
Subject: Re: [c-nsp] rtg

On Tue, Feb 27, 2007 at 08:04:38PM -0800, Shaun wrote:
> I know this is off topic, but does anybody know what happened to the RTG 
> project?  I know the site and src still exists on sourceforge but the 
> mailing lists are broken and have been for a while now... I was hoping 
> to get info from there lists about how to improve performance because 
> rtgplot sucks when it comes to creating graphs quickly on large 
> databases...  If anybody knows anything or if the lists moved somewhere 
> else let me know!

the main developer seems to have lost interest and the folks he left the
source code with aren't exactly responsive or making much progress in
recent times.

i did some modifications to improve rtgpoll (not rtgplot) performance
and features:

http://mu.org/~billf/yrtg/

but the patches don't apply to the current cvs tree. the diff is probably
as large as the codebase for rtgpoll itself. my commit access to rtg was
denied (?) so any future work i do will be a fork.

-- 
- bill fumerola / billf at FreeBSD.org