As usual, Gary has nailed it.
I can think of many ways of cutting down the number of queries (in
particular, fetch all the daily sums and counts in one query), but I don't
think we have an actual problem. Yes, this is not the most efficient
algorithm, but it is easy to understand, and it does not
On Tuesday, November 14, 2017 at 10:20:16 AM UTC-5, Clay Jackson wrote:
>
> My “day job” is supporting Quest Foglight (a database monitoring tool) –
> just for fun, I pointed it at the weewx database.
>
clay,
is there any chance you could point that profiling tool at a weewx instance
that is