[ On Friday, February 25, 2000 at 14:43:26 (+0100), Szokoli Gabor wrote: ]
> Subject: Re: [tkined] SQL Databases...
> On Thu, 24 Feb 2000, Stuart wrote:
> >
> > Yeah, I'm on Cary's side here. Storing large numbers of measurement
> > "tuples", matching them up with previous data (like for delta
> > computation),
>
> I always feared that.
> I am struggling between two main concepts about counters:
> -storing them raw
> -storing them smart (deltas, reboots noticed, etc)
>
> I came up with a looong SQL statement that returned the deltas to be used
> in reports, but it strained the DBserver, and was highly inefficient.
> If anyone has a good one handy, that may change my perception of the
> world.
I'm not such a big fan of SQL.
However I am beginning to be a big fan of RRDtool. It's designed
explicitly for the purpose of storing relatively(*) large amounts of
SNMP data in ways that make it both quick to store and easy to retrieve
(it of course stores in the the "smart" way):
http://ee-staff.ethz.ch/~oetiker/webtools/rrdtool/
(*) One person reports updating a database with ~17,000 new values every
minute, though I don't think the number of rows kept was reported.
- --
Greg A. Woods
+1 416 218-0098 VE3TCP <gwoods@acm.org> <robohack!woods>
Planix, Inc. <woods@planix.com>; Secrets of the Weird <woods@weird.com>
------- End of forwarded message -------
-- !! This message is brought to you via the `tkined & scotty' mailing list. !! Please do not reply to this message to unsubscribe. To subscribe or !! unsubscribe, send a mail message to <tkined-request@ibr.cs.tu-bs.de>. !! See http://wwwsnmp.cs.utwente.nl/~schoenw/scotty/ for more information.
This archive was generated by hypermail 2b29 : Mon Jan 08 2001 - 15:27:38 MET