Thanks, Tom! I can get the times tonight. MarisDB will cache some stuff, will have to see how to tune it.
Sent from my iPhone Clay Jackson > On Nov 14, 2017, at 11:04 AM, Thomas Keffer <[email protected]> wrote: > > 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 >> >> >> >> >> >
