Hello and sorry if that topic was discussed already....i found several similar discussions already but still dont know what is the best way to solve it.
I run a rental villa with 6 bed
That means, Nodered on a Pi4 here in Austria subscribes an MQTT broker in Thailand and gets every 30 seconds information about door and motionsignals in the villa,... also many other informations...
I get information graphs like in the attached picture about motion events and door events.
I want to see the last hour in detail and also the last 12 hours. Thats not much information at all,
mut in the mithod I use now, thats too much points in the graph and it makes the dashboard extremely slow, espacially when I use remote access. All togerther I have about 25 graphs in the flow
How can I simplyfy the job for the pi4 to get the same graph at the end?
Some solutions could be:
It would be much easier if I would just make a new point omly when something changes, but then it would draw diagonal lines in the graph...Also the time frame seems to be adjusted by the system, I could not get it fixed the last 12 hours
Someone also told me that an SSD USB Harddisk could be used instaad the CF card to get the system faster. Would that make sense?
Maybe there is just another graph node with more suitable settings for my case?
another solution could be to split the jobs in 2 Pi 4s, 1 for the graphs and the other for the none graphic jobs...
What is your suggestion?
Thanks in advance