I agree with Thomas on his points. The only thing I would have to add is that if you have many data sources in a temporary RRD or tons of rows in your oracle DB, then you may have some performance impacts when creating this on the fly.
I chose to keep data in both because I do custom reporting off the oracle db and display trend graphs from the RRD databases. My oracle DB has over 150 million rows in it and to pull that info out and create an RRD on the fly and then query from that would take my server down no matter how good my summary tables are set up since I need data for daily, weekly, monthly and yearly time periods. I guess it depends on how much data you have and the frequency you need it. HTH ReedK -----Original Message----- From: Thomas Erskine [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 7:28 AM To: Lozovsky, Daniel; rrd-users@list.ee.ethz.ch Subject: [rrd-users] Re: Integrating Oracle with RRDTOOL At 23:49 2003-07-02, Lozovsky, Daniel wrote: >Thanks Reed for your reply. >Let me clerify what I am asking. I am trying to query the oracle database >on the fly and create graphs based on the selected data using rrdtool. I am >trying to find out how to setup rrdtool to accomplish this task. I do not >want to keep redundant data in rrdtool but point the tool to generate graphs >directly from the data in the Oracle database. > >Is this possible? If so, how? No. You would have to create a temporary RRD, populate it with the information of interest and generate the graph off that rrd. It can be done on the fly; I've done it. You really want to make sure you clean up those temp rrds, or you can run out of disk space really quickly with significant data sets. >-- >Unsubscribe mailto:[EMAIL PROTECTED] >Help mailto:[EMAIL PROTECTED] >Archive http://www.ee.ethz.ch/~slist/rrd-users >WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi Thomas Erskine <[EMAIL PROTECTED]> +1.613.591.8490 -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi