You say that in 24 hours you have 10 million points. This seems less like an influxdb issue and more like a “my browser is choking on the amount of data that Influx is giving me” issue
When you go to the query inspector in your Grafana panel and expand the JSON data, how many points are being rendered?
Here’s an example from one of my dashboards:
q:"SELECT sum("ifHCInOctets") FROM "30d"."ifMIB_basics" WHERE ("carrier_name" =~ /^Hurricane
Electric$/) AND time >= now() - 3h GROUP BY time(1m) fill(null);SELECT sum("ifHCOutOctets") FROM
"30d"."ifMIB_basics" WHERE ("carrier_name" =~ /^Hurricane Electric$/) AND time >= now() - 3h
GROUP BY time(1m) fill(null)"
values:Array <---- look here
If that number above is high, then you need to tweak your dashboard/panel so that you’re not returning so many results in the series (you already noted that loading 15 minutes takes less time - this is because the points returned would be in the tens of thousands, rather than the hundreds of thousands or millions), or you need to create RPs/CQs so that the data you want to graph isn’t so vast. 10 million points in a 24 hour period is a huge amount of data. Influx will happily return it all, but that doesn’t mean your browser will like it.