Quote
My issue here is that I store an entry every 2 minutes, which means there is too much data to deal with when 7 days are displayed.
But 5040 points on a graph gets unnecessarily busy.
So this is only a
User Interface issue? How disappointing ;-)
Just because you
store your data every 2 minutes doesn't necessarily mean that you have to
display it that way.
Look into the "group by" clause and Aggregate functions, e.g. Average(), and apply these to your data, grouping by whatever Temporal unit (e.g. hours) you choose to display. OK, the query will look a bit heavyweight and may run a little slower, having to do the extra work, rolling all those values together, but it should get you what you need.
Alternatively, just retrieve the raw data and process them further at the application end. YMMV.
Regards, Phill W.