Better performance!

thomasN · Post by **thomasN** » Fri Nov 19, 2004 9:49 am

When you open the graph tree I can see that there is one select for every device added. We have approx 200 so this takes a while. And this doesn't seem to happen simultaneously but one at a time.

And when you have reached a host and click 'Interface - Traffic' to display all traffic graphs for one host I can see that the same number of selects are done once again.

Couldn't this be read and cached in some way? Sure takes a lot of time to browse around looking at graphs if you don't have only 5 devices.

Post by **rony** » Fri Nov 19, 2004 10:02 am

This is the way the tree works. We are re-evaluating how it works, possible options are using frames, or sub trees, etc.

Post by **TheWitness** » Fri Nov 19, 2004 11:23 pm

Tony,

I posted a fix to both MAIN (0.8.7) and BRANCH_0_8_6 CVS' tonight. It uses a session variable to hold the query results that speeds things up a bit. It times out based upon the page refresh setting in "Graph Settings". This will make it poll the MySQL server less, but it is still CPU intensive on the server.

I have close to 200 hosts at the office and when you select to "Expand Hosts" it is gruesome.

There is currently a warning message with the code. I will fix that tomorrow.

Larry

Post by **rony** » Sat Nov 20, 2004 2:14 pm

Not only can that be CPU intensive, but it can be memory intensive. I don't know if that is a good idea.

We will figure it out. Send me an email about it.

thomasN · Post by **thomasN** » Sat Nov 20, 2004 3:32 pm

TheWitness wrote:Tony,

Who's Tony?

Post by **rony** » Sat Nov 20, 2004 5:25 pm

Me....

Lol, I should sign my real name?

Post by **TheWitness** » Sat Nov 20, 2004 6:33 pm

Tony,

The whole thing is way ugly. I have a few ideas. Will be working late tonight.

Larry

thomasN · Post by **thomasN** » Wed Dec 08, 2004 1:17 am

Just an idea... is it possible to use links/wget/whatever in some way perhaps top make a static copy of the entire graph view of cacti?

So you could point your users to that instead of the live one. That would speed thinks up. Maybe not zoom but just for viewing the graphs in it's simplest form.

Post by **TheWitness** » Wed Dec 08, 2004 6:52 am

Thomas, this may not be a feature request. Look at "Settings->Graph Export". I didn't write it, but I "think" it accomplishes what you want.

Larry

drub · Post by **drub** » Thu Dec 09, 2004 1:28 pm

I think the Host: feature under graph tree would work best if when you submit the query to enter that as a new graph tree item it populates the graph_tree_items as it would appear in the tree view,

Basically when you use the Host: feature now everytime you load the graph_view?action=tree it has to query mysql for every item that belongs to the host rather than just read the contents of graph_tree_items, it would be great if it built these host: trees in that table.

thomasN · Post by **thomasN** » Thu Mar 10, 2005 8:56 am

Hi

Has there been any progress on this matter? With our 6929 graphs / 149 devices it takes +60 seconds for every click in the graph menu (when selecting something).

And that's on a pretty fast machine...

Cacti

Better performance!

Better performance!

Who is online