Performance Problem with 0 Value Graphs

[Saftnase]

Hi,

i recently made the Update to 1.6.2, and yes man i love it

But i have one small issue.
When monitoring the Network Interfaces of our Routers and display a Graph of an Interface with traffic, even with only one Byte transmitted, the Graph is generated in 0,13 sec. But when there is no traffic (e.g. Backup Interface) the Graph needs about 30 sec. to be generated.

To make it clear, no traffic does not mean no values received, but all the values are 0.

btw. did i mention that i love the 1.6 version
Great Work Alexei and Team.

[Saftnase]

Does anyone have the same issue ?

[Alexei]

It is very likely that the problem is already fixed in pre-1.6.3. It was related to inefficient handling of certain SQL queries by MySQL and possibly other DB engines.

[Saftnase]

Glad to hear that, its a real pain to wait so long for graphs showing nothing

[serge.lenz]

It is very likely that the problem is already fixed in pre-1.6.3. It was related to inefficient handling of certain SQL queries by MySQL and possibly other DB engines.

I think problem not in queries.
I only can say what problem probably in the include/classes/chart.inc.php, draw() function. I put debug logging with timestams before and after call $this->drawElement() and see what this function takes more and more time to complete.
Also I try to download and install nightly build but it not help and as I see chart.inc.php is not changed from 1.6.2 version.

[Saftnase]

Hi,
i updated to 1.6.4 and the problem is still alive.