That's interesting! Several things need the outside temperature: sunrise and sunset calculations, reduction of barometric pressure to the sea-surface pressure, and ET.
I think Sqlite is smart enough to cache the needed pages. Can your tool make an estimate of the time spent in each query? -tk On Tue, Nov 14, 2017 at 7:20 AM, Clay Jackson <[email protected]> wrote: > 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 > > > > >
