Gary, Thanks, not sure why my dB was so small, but at this point doesn't really matter I guess.
Cheers! Chip On Thursday, November 18, 2021 at 1:38:33 PM UTC-7 gjr80 wrote: > 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/0e32f5a3-2117-41fb-bbcf-0bfdfe087977n%40googlegroups.com.
