Thanks for the reply Vince. I had upgraded to V4, do not recall if I used the extended schema unless the default setting then I likely went with that option. Good to hear that the size of the database is not connected to RAM. Nice to know performance shouldn't be impacted and it sounds like my current file size is closer to the norm so I don't need to worry it will increase to many GB next year. Thanks again!
On Thursday, November 18, 2021 at 11:25:17 AM UTC-7 vince wrote: > Database size has nothing to do with the amount of RAM your computer has, > nor how much RAM weewx needs (which is not much). > > If you upgraded to v4 and used the extended schema, yes it added a lot of > typically unused fields and tables, but it didn't increase the size > tremendously. I did the measurement before and after during the > development cycle and it was visible but not anything too significant. > > My database going back 15 years (wow) now is 352 MB in size for my VP2 on > a 5-minute interval period. Tiny these days. > > On Thursday, November 18, 2021 at 10:08:15 AM UTC-8 [email protected] > wrote: > >> I have Weewx running on a RaspberryPi and am changing out the SD card >> which was behaving badly. In the process I noticed that the database has >> grown significantly in the 1 year since I had performed my last software >> update. Last year the database was about 950KB and I believe (but could be >> wrong) this covered several years of operation and today it is 145MB. >> >> The growth concerns me and I would like to understand what is causing it >> and how this impacts the performance of the RPi which is older and has very >> little RAM (512M) by todays standards. I know enough about databases to be >> very dangerous but am not afraid to dig into it. >> >> So any help or advice would be much appreciated. >> >> Chip >> > -- 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/776ec494-5ba6-4374-8243-3a5a8ba023f7n%40googlegroups.com.
