Thanks I should have said i'm using mariadb ... I think that has an OPTIMISE TABLE equivalent to VACUUM, but no I have not used it (I'll experiment on an off line database). It wasn't clear to me what extra derived types I needed, and the extended schema should give me future compatibility ... so no regrets other working out how I will back it up.
On Friday, 14 August 2026 at 21:14:04 UTC+1 Tom Keffer wrote: > Have you tried the VACUUM <https://sqlite.org/lang_vacuum.html> command? > > Also, you did not need to switch to the wview-extended schema, just add > columns for any derived types. See *Troubleshooting V5 performance issues > <https://github.com/weewx/weewx/wiki/v5-performance-troubleshooting>*. > > On Fri, Aug 14, 2026 at 1:04 PM Bob Atchley <[email protected]> wrote: > >> Raspbian BullsEye is end of life at the end of August 2026 (2 weeks time >> as I write this). >> With the number of security issues being dug up by AI, doing nothing is a >> high risk strategy. >> >> I decided to make the move to Ubuntu 26.04 on my RPi4 (giving a upgrade >> path going forward) and of course the latest weewx version (5.5.0). >> >> The biggest hurdle is that weewx doesn't break, so not touched it for >> years and I have forgotten everything. >> Great documentation and the Wiki are the saving graces. >> >> On BullsEye I was running a very early (beta) release of weewx 5.0 using >> the old database schema and just using the standard Seasons Skin, >> I realised I had a serious performance issue after the upgrade: >> >> Before: >> user.log.1:Aug 8 23:25:21 rpi4 weewx[965] INFO weewx.imagegenerator: >> Generated 10 images for report SeasonsReport in 0.74 seconds >> user.log.1:Aug 8 23:30:21 rpi4 weewx[965] INFO weewx.cheetahgenerator: >> Generated 8 files for report SeasonsReport in 2.28 seconds >> >> After: >> 026-08-14T14:37:47.234310+00:00 rpi4 weewxd[5648]: INFO >> weewx.cheetahgenerator: Generated 8 files for report SeasonsReport in >> 144.66 seconds >> 2026-08-14T14:43:52.117916+00:00 rpi4 weewxd[5648]: INFO >> weewx.imagegenerator: Generated 10 images for report SeasonsReport in >> 364.88 seconds >> >> so 4 seconds to write the reports before, 500 seconds after, with 100% >> CPU usage. Disappointing. >> >> Reading between the lines more use is being made of the extended database >> schema, causing a large overhead if still using the old schema. >> So I followed the Wiki: >> >> https://github.com/weewx/weewx/wiki/Switching-to-the-new-wview_extended-schema >> >> >> This solved the performance issues: >> 2026-08-14T18:40:28.340408+00:00 rpi4 weewxd[7306]: INFO >> weewx.cheetahgenerator: Generated 8 files for report SeasonsReport in 5.37 >> seconds >> 2026-08-14T18:40:29.342990+00:00 rpi4 weewxd[7306]: INFO >> weewx.imagegenerator: Generated 10 images for report SeasonsReport in 1.00 >> seconds >> >> This is perfectly acceptable performance. >> >> The downside is my database when backed up is now 1.4GB (95MB gzipped) - >> basically double the size from before. >> >> My backup strategy has been to use google cloud (via rclone) but I was >> getting bandwidth limit errors before this increase of size. >> Still need to work out how to fix this. >> >> Hope this helps anyone else doing something similar >> >> Cheers >> >> Bob >> >> -- >> 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 visit >> https://groups.google.com/d/msgid/weewx-user/430e8248-f7a5-401d-8fb1-d3807c2baed5n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/430e8248-f7a5-401d-8fb1-d3807c2baed5n%40googlegroups.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 visit https://groups.google.com/d/msgid/weewx-user/392bae75-b470-4027-b088-0064ec27bc4an%40googlegroups.com.
