My “day job” is supporting Quest Foglight (a database monitoring tool) – just for fun, I pointed it at the weewx database.
It generally looks pretty good – but, there’s ONE query against archive_day_outTemp that’s executing 5,300 times/day (the next nearest is about 750/day). Here’s the query SELECT SUM(`wsum`), SUM(`sumtime`) FROM `archive_day_outTemp` WHERE DATETIME >= ? AND DATETIME < ? I AM using Alarm_Multi to check outdoor temps below freezing; but, there’s a 3600 second “timer” on that. Anyone have any ideas? Clay Jackson
