Struggling with con...
 
Notifications
Clear all

[Solved] Struggling with concept of WAL files  

Picard
(@sevenofnine)
New Member

Hi guys,

Im struggling with write ahead logs and understanding them. I get the concept that it is basically a role back journal in reverse and any data, say web history for example, is written to the log and then committed to the actual database at a checkpoint thats either automatic at 1000 pages or forced by design. Am I correct in saying this is to save multiple writes to disk? But, if this log is written to disk how are we saving on writes? If the file is held in memory then this would make more sense to me but I cant find much detail around this.

I appreciate its highly likely I am missing a very simple concept here so I apologise upfront.

Thanks

P

Quote
Topic starter Posted : 02/12/2020 9:17 am
minime2k9
(@minime2k9)
Active Member

I recently did a bit of a write-up on WAL files:

https://askclees.com/2020/10/11/timelining-using-sqlite-write-ahead-logs/

Might be useful to you, it does explain about them outside of using them for timelining

ReplyQuote
Posted : 02/12/2020 2:34 pm
trewmte liked
Picard
(@sevenofnine)
New Member

Thanks minime2k9, very in depth explanation. I scanned through it but to be honest beed to take some time to read it in detail and come back to you.

Thanks again.

ReplyQuote
Topic starter Posted : 02/12/2020 7:11 pm
Share: