Thanks for the feedback Tom

On Sun, Dec 15, 2019 at 1:19 PM Thomas Keffer <[email protected]> wrote:

> I'm surprised it would make much of a difference. Vacuum is useful when
> your data goes through a lot of insertions and deletions, causing the disk
> file to get very fragmented. See the sqlite documentation
> <https://www.sqlite.org/lang_vacuum.html> for details. WeeWX doesn't work
> like this: it just adds data, never deletes.
>
> Some of the extensions, "forecast" in particular, delete old data. For
> them, it might make sense.
>
> If you're still intent on adding vacuum, then you should use a cron job.
> Make sure you stop WeeWX first.
>
> -tk
>
> On Sun, Dec 15, 2019 at 10:04 AM John Schultz <[email protected]>
> wrote:
>
>> Is it possible to get sqlite "vacuum" as a user selected with a "yes" or
>> "no" in weewx.conf. Intervals could be hourly, daily, weekly etc. The
>> database grows rapidly when the archive interval is set low (1 minute) on a
>> Vantage device. Vacuum helps with this. I could set up a cron job to handle
>> this but then this gets outside the realm of wee.
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "weewx-user" 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-user/a003dd09-43c4-469b-87f9-ccf7345f2973%40googlegroups.com
>> <https://groups.google.com/d/msgid/weewx-user/a003dd09-43c4-469b-87f9-ccf7345f2973%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
> --
> 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/0RXRjaRmtjs/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/CAPq0zEDACC8U3fOMGpTRRVN6Btp0MYxW6q-NAWiFkG%2B1U-QNkw%40mail.gmail.com
> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEDACC8U3fOMGpTRRVN6Btp0MYxW6q-NAWiFkG%2B1U-QNkw%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"weewx-user" 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-user/CAEHmWgn0hKGgiXzuyb_E%3Dp-KNUcz9xHjSsuE12jdy9Nrshftfg%40mail.gmail.com.

Reply via email to