When creating Graphs, the process may become slower over time as more items exist #5451
Description
Describe the bug
As reported by a user, he found that as more graphs got created, Cacti became progressively slower. I've reviewed the query and found it flawed and missing an important join attribute. Problem is reported here:
http://forums.cacti.net/viewtopic.php?p=291546#p291546
To Reproduce
Steps to reproduce the behavior:
-
Create many thousands of graphs user add_graphs.php CLI script for Data Query graphs searching for a specific 'data_source_name'
-
Watch as Cacti get's slower and slower as more are created.
Expected behavior
Cacti should handle these queries very quickly.