Re: [weewx-development] Query against archive_day_outTemp

2017-11-19 Thread Thomas Keffer
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

[weewx-development] Re: Query against archive_day_outTemp

2017-11-19 Thread mwall
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