We have seen this before. The problem turned out to be the use of synthetic types.
For example, if ET is not in your database, V5 will calculate it on the fly, which can be slow. V4.10 would just return the tag. To find the culprit, you'll have to first isolate the template that is causing the problem, then start deleting tags until you see a difference in runtime. Slow, but it will work. Or, it's possible it's something else. Let us know what you find. -tk On Mon, Jan 15, 2024 at 7:53 AM [email protected] <[email protected]> wrote: > Hi, > > After Updating from 4.10.2 to 5.0.0 Report generation seems to be very > slow with Belchertown Reports. > Before Update, it runs in 1.59 seconds after approx. 133 seconds. I don't > know from which this come. During runtime, one Python Process takes 100% CPU > > Here are some Logs: > > With 4.10.2 > Jan 14 00:05:17 wetter weewx[1711685] INFO weewx.manager: Added record > 2024-01-14 00:05:00 CET (1705187100) to database 'weewx.sdb' > Jan 14 00:05:17 wetter weewx[1711685] INFO weewx.manager: Added record > 2024-01-14 00:05:00 CET (1705187100) to daily summary in 'weewx.sdb' > Jan 14 00:05:18 wetter weewx[1711685] INFO weewx.restx: PWSWeather: > Published record 2024-01-14 00:05:00 CET (1705187100) > Jan 14 00:05:18 wetter weewx[1711685] INFO weewx.restx: Wunderground-PWS: > Published record 2024-01-14 00:05:00 CET (1705187100) > Jan 14 00:05:18 wetter weewx[1711685] INFO weewx.cheetahgenerator: > Generated 8 files for report SeasonsReport in 0.71 seconds > Jan 14 00:05:18 wetter weewx[1711685] INFO weewx.imagegenerator: Generated > 15 images for report SeasonsReport in 0.29 seconds > Jan 14 00:05:18 wetter weewx[1711685] INFO weewx.reportengine: Copied 0 > files to /var/www/html/weewx > Jan 14 00:05:20 wetter weewx[1711685] INFO weewx.cheetahgenerator: > Generated 12 files for report Belchertown in 1.59 seconds > Jan 14 00:05:20 wetter weewx[1711685] INFO weewx.reportengine: Copied 3 > files to /var/www/html > > after weewx 5.0 > > Jan 15 16:20:17 wetter weewxd[1530]: INFO weewx.manager: Added record > 2024-01-15 16:20:00 CET (1705332000) to database 'weewx.sdb' > Jan 15 16:20:17 wetter weewxd[1530]: INFO weewx.manager: Added record > 2024-01-15 16:20:00 CET (1705332000) to daily summary in 'weewx.sdb' > Jan 15 16:20:17 wetter weewxd[1530]: INFO weewx.restx: Wunderground-PWS: > Published record 2024-01-15 16:20:00 CET (1705332000) > Jan 15 16:20:18 wetter weewxd[1530]: INFO weewx.cheetahgenerator: > Generated 8 files for report SeasonsReport in 0.53 seconds > Jan 15 16:20:18 wetter weewxd[1530]: INFO weewx.imagegenerator: Generated > 15 images for report SeasonsReport in 0.28 seconds > Jan 15 16:20:18 wetter weewxd[1530]: INFO weewx.reportengine: Copied 0 > files to /var/www/html/weewx > Jan 15 16:20:18 wetter weewxd[1530]: INFO weewx.restx: PWSWeather: > Published record 2024-01-15 16:20:00 CET (1705332000) > Jan 15 16:21:01 wetter CRON[12091]: (root) CMD > (/root/get_picture_camera1.sh >/dev/null 2>&1) > Jan 15 16:21:01 wetter CRON[12094]: (root) CMD > (/root/get_picture_webcam.sh >/dev/null 2>&1) > Jan 15 16:21:01 wetter CRON[12093]: (root) CMD > (/root/get_picture_camera2.sh >/dev/null 2>&1) > Jan 15 16:22:01 wetter CRON[12139]: (root) CMD > (/root/get_picture_camera1.sh >/dev/null 2>&1) > Jan 15 16:22:01 wetter CRON[12140]: (root) CMD > (/root/get_picture_webcam.sh >/dev/null 2>&1) > Jan 15 16:22:01 wetter CRON[12138]: (root) CMD > (/root/get_picture_camera2.sh >/dev/null 2>&1) > Jan 15 16:22:31 wetter weewxd[1530]: INFO weewx.cheetahgenerator: > Generated 12 files for report Belchertown in 133.14 seconds > Jan 15 16:22:31 wetter weewxd[1530]: INFO weewx.reportengine: Copied 3 > files to /var/www/html > > with debug=1 i see > > Jan 15 16:45:17 wetter weewxd[12965]: INFO weewx.manager: Added record > 2024-01-15 16:45:00 CET (1705333500) to database 'weewx.sdb' > Jan 15 16:45:17 wetter weewxd[12965]: INFO weewx.manager: Added record > 2024-01-15 16:45:00 CET (1705333500) to daily summary in 'weewx.sdb' > Jan 15 16:45:18 wetter weewxd[12965]: INFO weewx.restx: Wunderground-PWS: > Published record 2024-01-15 16:45:00 CET (1705333500) > Jan 15 16:45:18 wetter weewxd[12965]: INFO weewx.restx: PWSWeather: > Published record 2024-01-15 16:45:00 CET (1705333500) > Jan 15 16:45:18 wetter weewxd[12965]: INFO weewx.cheetahgenerator: > Generated 8 files for report SeasonsReport in 1.13 seconds > Jan 15 16:45:19 wetter weewxd[12965]: INFO weewx.imagegenerator: Generated > 15 images for report SeasonsReport in 0.34 seconds > Jan 15 16:45:19 wetter weewxd[12965]: INFO weewx.reportengine: Copied 5 > files to /var/www/html/weewx > Jan 15 16:45:19 wetter weewxd[12965]: INFO user.belchertown: version 1.3.1 > Jan 15 16:46:01 wetter CRON[13306]: (root) CMD > (/root/get_picture_camera2.sh >/dev/null 2>&1) > Jan 15 16:46:01 wetter CRON[13305]: (root) CMD > (/root/get_picture_camera1.sh >/dev/null 2>&1) > Jan 15 16:46:01 wetter CRON[13307]: (root) CMD > (/root/get_picture_webcam.sh >/dev/null 2>&1) > Jan 15 16:47:01 wetter CRON[13357]: (root) CMD > (/root/get_picture_camera1.sh >/dev/null 2>&1) > Jan 15 16:47:01 wetter CRON[13358]: (root) CMD > (/root/get_picture_camera2.sh >/dev/null 2>&1) > Jan 15 16:47:01 wetter CRON[13360]: (root) CMD > (/root/get_picture_webcam.sh >/dev/null 2>&1) > Jan 15 16:47:31 wetter weewxd[12965]: INFO weewx.cheetahgenerator: > Generated 12 files for report Belchertown in 132.16 seconds > Jan 15 16:47:31 wetter weewxd[12965]: INFO weewx.reportengine: Copied 40 > files to /var/www/html > > -- > 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/c18f5ddb-c2a9-4ba5-bfd2-31c7b4af03a5n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/c18f5ddb-c2a9-4ba5-bfd2-31c7b4af03a5n%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 on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zECkf%3DLmHw4N%2B1rcFrNLxWMm2DSqhhCUwsfeGgnh7XRzfA%40mail.gmail.com.
