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.

Reply via email to