On 1/8/22 12:09 AM, David C. Rankin wrote:
On 1/6/22 10:13 AM, Bob Rogers wrote:
From: Istvan Gabor <suseuser04@gmail.hu> Date: Thu, 06 Jan 2022 12:23:47 +0100
Hello:
Currently I use firefox 91.4.1esr in openSUSE 15.3.
I noticed that in the profile directory the size of some sqlite database files does not change after deleting history. Namely, places.sqlite, favicons.sqlite, cookies.sqlite files' size remains the same after deleting history.
Why don't the file sizes decrease after deleting their content by deleting history?
From the SQLite docs [1]:
When content is deleted from an SQLite database, the content is not usually erased but rather the space used to hold the content is marked as being available for reuse.
But unless you want to use the SQLite command-line client to do this for yourself, you'll have to wait for Firefox to get around to doing it for you.
-- Bob Rogers http://www.rgrjr.com/
I wrote the following to vacuum the sqlite files in both .mozilla and .thunderbird. sqlite is a horribly wasteful database format when used over a long period of time without vacuuming the stale space.
If the attachment doesn't come though, I'll post to paste.opensuse. Should work when run from konsole or an xterm just fine even though it was written several years ago (it looks for sqlite3)
I got the attached file