Instead, upon every transaction commit, freelist pages are moved to the end of theĭatabase file, and after that the file is truncated to exclude these pages. If "auto_vacuum" is set to "full", no freelists are kept inside the database. This is good for a forensic investigator: by default, there are freelists inĮvery SQLite database. Unused database file pagesĪnd reused for subsequent inserts. Quoting, "When auto-vacuum is disabled and data is deleted dataįrom a database, the database file remains the same size. Particularly, auto_vacuum specifiesīy default, this setting is set to "none", which means that auto-vacuum is disabled. SQL extension, which affects the way SQLite works. Auto_vacuum, secure delete, and how they affect forensic investigationĪn "auto_vacuum" is one of the so-called "pragma statements", a SQLite-specific There is an exception though: an option called "auto_vacuum", affects whetherįreelist exists in a database or not. Immediately instead, it goes to a freelist. In a nutshell, when some data is deleted from a SQLite database, it is not deleted Unused pages are stored on the freelist and are reused when additional pages are Unused pages can come about, for example, when information is deleted from the database. "A database file might contain one or more pages that are not in active use. Here is how explains the meaning of freelists: Such unused pages in the database file are stored on what is called These pages may be createdĪnd reserved for future use to improve performance in this case, they contain no Page numbering startsĪ SQLite database may have one or more unused pages.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |