search

steepleian / weewx-Weather34

Other
44 stars 9 forks source link

lastnonzero.py #152

Open Damien0505 opened 9 months ago

Damien0505 commented 9 months ago

Hi Ian,

Just wondering what the importance of lastnonzero.py is to the operation of weewx-Weather34?

The reason I ask is due to this service absolutely slamming the database recently searching through the whole archive table, strangely enough either for lightning_distance or signal5.

I have removed it for the time being from weewx.conf (xtype_services: user.lastnonzero.LastNonZeroService)

In the case it is unnecessary I'll leave it disabled.

Kind regards, Damien

steepleian commented 9 months ago

Those two columns need to be added to your database then all will be well. The successor DivumWX will check during the install process to see if they are there and if not encourage you to add them. Lastnonzero annd the extra columns are required if you have a lightning device. Sent from my iPad.On 7 Feb 2024, at 16:36, Damien @.***> wrote: Hi Ian, Just wondering what the importance of lastnonzero.py is to the operation of weewx-Weather34? The reason I ask is due to this service absolutely slamming the database recently searching through the whole archive table, strangely enough either for lightning_distance or signal5. I have removed it for the time being from weewx.conf (xtype_services: user.lastnonzero.LastNonZeroService) In the case it is unnecessary I'll leave it disabled. Kind regards, Damien

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: @.***>

Damien0505 commented 9 months ago

I don't have a lightning device connected, and I do have the columns in the weewx archive table.

The issue seems to be that the query begins searching through all records, and then is restarted by (possibly) weewx after a minute or three, causing the same query to be constantly running over and over.

Regards, Damien