I’m using the Standard Skin – modified a bit – Prosser, WA USA Current Weather Conditions (n7qnm.net) <https://www.n7qnm.net/weewx/Standard/index.html>
I was surprised at that SPECIFIC query would get executed so many times- is it looking up some sort of range, or …… From: Tom Keffer <[email protected]> Sent: Wednesday, July 24, 2024 1:18 PM To: Clay Jackson <[email protected]> Cc: weewx-development <[email protected]> Subject: Re: [weewx-development] Database Query Performance That doesn't completely surprise me. WeeWX makes no attempt at database caching. That's what keeps it simple. Still, that does seem like a lot. Assuming a 5 minute archive interval, that's 2600 times per reporting cycle. What skin, and have you modified it? On Wed, Jul 24, 2024 at 9:45 AM Clay Jackson <[email protected] <mailto:[email protected]> > wrote: In my "day job" I do database tuning - so, I took some of the tools (Foglight, Quest Software) has and did a quick analysis of the weewx (mySQL) database. I was REALLY surprised to see that in a 24 hour period, this query was executed 735,000 times: SELECT SUM ( `wsum` ) , SUM ( `sumtime` ) FROM `archive_day_outTemp` WHERE DATETIME >= ? AND DATETIME < ? The next highest query was only executed 55,000 times: SELECT MAX ( DATETIME ) FROM `archive` Any thoughts on this? -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/59953b14-9c47-41bf-ae73-b85ae56680ben%40googlegroups.com <https://groups.google.com/d/msgid/weewx-development/59953b14-9c47-41bf-ae73-b85ae56680ben%40googlegroups.com?utm_medium=email&utm_source=footer> . -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/398d01dade07%24c7112d60%2455338820%24%40n7qnm.net.
