Re: [tkined] SQL Databases...

From: Greg A. Woods (tkined-fwd@mail.weird.com)
Date: Mon Feb 28 2000 - 17:59:50 MET

[ 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