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]> 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]. > 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/CAPq0zEDBUmiX9Tpt44yMeS0ZpBiNkbds2OSZDGc-v8yv%3Dez8Fw%40mail.gmail.com.
