DB size vs Wal file

Topics (not sure which fora)
when not sure where to post, post here and mods will move it to right forum.

Moderators: leecollings, remb0

Post Reply
YellowSky
Posts: 65
Joined: Tuesday 12 May 2015 12:09
Target OS: Raspberry Pi / ODroid
Domoticz version: Last
Location: Belgium
Contact:
Contact YellowSky

DB size vs Wal file

Post 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
Last edited by YellowSky on Wednesday 29 March 2023 5:12, edited 1 time in total.
Top
User avatar
kiddigital
Posts: 439
Joined: Thursday 10 August 2017 6:52
Target OS: Raspberry Pi / ODroid
Domoticz version: Beta
Location: Netherlands
Contact:
Contact kiddigital

Re: DB size vs

Post by kiddigital »

Maybe read https://www.theunterminatedstring.com/sqlite-vacuuming/
One RPi with Domoticz, RFX433e, aeon labs z-wave plus stick GEN5, ha-bridge 5.4.0 for Alexa, Philips Hue Bridge, Pimoroni Automation Hat
One RPi with Pi foundation standard touch screen to display Dashticz
Top
YellowSky
Posts: 65
Joined: Tuesday 12 May 2015 12:09
Target OS: Raspberry Pi / ODroid
Domoticz version: Last
Location: Belgium
Contact:
Contact YellowSky

Re: DB size vs

Post by YellowSky »

I understand the principle but is it safe for domoticz?
Top
willemd
Posts: 662
Joined: Saturday 21 September 2019 17:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2024.1
Location: The Netherlands
Contact:
Contact willemd

Re: DB size vs Wal file

Post 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.
Top
Post Reply

Return to “Other questions and discussions”

Who is online

Users browsing this forum: No registered users and 1 guest