Dear all,
I have domoticz 4.97 running on raspberrypi connected with daenetip4 denkovi board.
I started to use the new hardware set for the board "Denkovi Modules with LAN (HTTP) Interface" as suggested on Denkovi website.
With this feature is possible to refresh state of input/output with a setted refresh time.
The problem is that if a swicth is on and the refresh is again on an entry in the database is performed and in this way the database become very big and hard to be manage. At the moment I have an update every 10 seconds also if the status does not change.
How can I solve this issue? From my point of view an entry on the database must be done only if the state is differente than the previous.
????
denkovi smartden IP
Moderator: leecollings
-
- Posts: 8
- Joined: Wednesday 31 January 2018 13:39
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2023.1
- Location: IT
- Contact:
denkovi smartden IP
Raspberry Pi 3b+ - Domoticz 2023.1
NodeRED
Solaredge inverter
NodeRED
Solaredge inverter
Re: denkovi smartden IP
I have the same problem with PIR devices filling up the database. I use an SQL commend to clear all entries except the last day like:
Code: Select all
#!/bin/bash
DAYS=1
/usr/bin/sqlite3 /home/pi/domoticz/domoticz.db "DELETE FROM lightinglog WHERE DeviceRowID IN (88,113,114,129) AND Date <= datetime( 'now', '-$DAYS day' );"
Who is online
Users browsing this forum: No registered users and 1 guest