Update time and database cleanup

[Jonis Maurin Ceará]

Hi.

Is there any database cleanup or summarization proccess in weewx?

I'm asking because I'm planing to change my archive time from 300 seconds to something about 30 or 60 seconds, but I'm concerned about database size (i'm planing to switch to MySQL too). With 30 seconds, it will be at least 2.880 rows per day, or about 1.000,000 a year.

WeeWx does any kind of summariozation? I mean, get the summarization of the day, insert new registry with this 'sum' and clear all small readings in database... (just an example).

I'm planing to change this update interval to make my local webpage (and services like WeatherUnderground) more updated.

Also, another question: there is a 'commom' update interval for most of hardware stations?? Like 30 seconds, 1 minute, etc...?

Tks!

[Andrew Milner]

A 'common' archive time is 300 seconds.  Most stations will output LOOP data at intervals ranging from every 2 seconds to 60 seconds depending on the station type.  Weewx never cleans up the archive records.  It does create 'daily summary' tables for each observation type (in addition to the detailed archive records) - which will give daily max, min and sum for each obsdervation type.  The archive records which weewx stores in the database will be either archive (log) records from the station or be calculated by weewx as being the averages of loop data received during the archive interval.

30 to 60 seconds for archive interval is probably too frequent - and could/will create possible problems with report generation - as reports are only generated on archive intervals, and suffiocient time must be allowed for the generation before the next archive event.

datasbase size is not an issue however.

loop records are not stored by weewx, but can be stored using the mesowx extension.

does this help or merely confuse you??

weewx never deletes or cleans up anything in the database automatically.

[Jonis Maurin Ceará]

Huummm......more or less.

I'm confused because I can see some stations in WeatherUnderground with frequently update time (30 seconds +-), but I'm now sure how to do this.

My loop interval is set to 5 seconds (which is the time that my C program updates TXT file for FileParer driver) and I would like to update services for 30 or 60 seconds, but I know that WeeWx just update services (and report page) when does Archiving, whih is, by default, 300 seconds.

So, my question is: there is any way to update services more often and keep archiving with 300 seconds? My Loop is already set to 5 seconds and my driver can fetch new data every 5 seconds.

--
You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/iB8JaLQm6eA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to weewx-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Andrew Milner]

Set rapid fire to true in wunderground section of weewx.conf – see the user guide – wunderground rapid fire is bound to the loop records.

 

 

 

Sent from Mail for Windows 10

--

To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

 

--

You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/iB8JaLQm6eA/unsubscribe.

To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com.

[Jonis Maurin Ceará]

Tks, I'll try right now!

--

To unsubscribe from this group and all its topics, send an email to weewx-user+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/iB8JaLQm6eA/unsubscribe.

To unsubscribe from this group and all its topics, send an email to weewx-user+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/iB8JaLQm6eA/unsubscribe.

To unsubscribe from this group and all its topics, send an email to weewx-user+unsubscribe@googlegroups.com.