Graphs hang "Loading..." after few minutes

[ragflyer]

I collected some data over past months, the db is about 500MB now and all is fine when I start up mycontroller. But after just a few minutes graphs will not load but instead show "Loading..." forever.
When I stop and start mycontroller, it works again for some time.
CPU and memory load seems fine in 'top'.

[jkandasa]

@ragflyer What type of data do you have? What type of graph are you trying to see? and duration.

500MB is too big

[ragflyer]

@jkandasa It is temperature, particle, CO2, rainfall etc. I try to collect data long term for later analysis, space is available, so maybe I should use another DB backend?

[jkandasa]

@ragflyer Yes, I guess InfluxDB will give you better result for metrics