Sounds to me like the starting size is the odd figure here - 950kb for ‘several years of data’ is rather low in my experience. I have a number of databases of simulator data covering various periods and the smallest of these is 2.6Mb for one month of data. It goes up from there. One year is 39Mb and 10 years 234MB. These are all wview schema.
I wouldn’t be concerned. Gary On Friday, 19 November 2021 at 04:25:17 UTC+10 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/1dfb88de-1896-44dd-9579-2c96fc74f3bfn%40googlegroups.com.
