Page 1 of 1

DB size vs Wal file

Posted: Tuesday 14 March 2023 4:56
by YellowSky
Hi everyone,
is it normal that the wal file of SQLITE db (transations) has a higher size than the db?
Is is the normal behaviour? Is there any way to reduce it? In my cas 30 Mo for the WAL file and 20 Mo for the db
Thank you

Re: DB size vs

Posted: Tuesday 14 March 2023 6:49
by kiddigital

Re: DB size vs

Posted: Wednesday 29 March 2023 5:12
by YellowSky
I understand the principle but is it safe for domoticz?

Re: DB size vs Wal file

Posted: Wednesday 29 March 2023 10:24
by willemd
The WAL file in my installation is also bigger than the DB file. I do not experience any problems as result of it. The daily switchover routine does a vacuum.