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.
