Compact feature for local.sqlite (executing VACUUM command)

NEW
Unassigned

Status

enhancement
13 years ago
7 years ago

People

(Reporter: omarb.public, Unassigned)

Tracking

Details

Reporter

Description

13 years ago
User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1) Gecko/20060915 BonEcho/2.0
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1) Gecko/20060915 BonEcho/2.0

When a calendar is deleted the size of storage.sdb doesn't change. The unused disk space is added to an internal "free-list" and is reused the next time data is inserted. What I propose is compact feature (like in thunderbird) to reduce the size of storage.sdb. Stefan Sitter mentioned about this site:
http://www.sqlite.org/faq.html#q14
I don't know anything about SQLite but I think VACUUM command can be implemented. What do you think? Is it possible?

Reproducible: Always

Comment 1

13 years ago
This should probably go over to Toolkit:Storage to be implemented on the mozIStorage interfaces.
Summary: Compact feature for storage.sdb → Compact feature for storage.sdb (run the VACUUM command)
OS: Windows XP → All
Hardware: PC → All
Status: UNCONFIRMED → NEW
Ever confirmed: true
Flags: wanted-calendar1.0?
Instead of adding explicit code, IMO we should use one of the more recent vacuum pragmas: <http://www.sqlite.org/pragma.html#pragma_auto_vacuum>.
Summary: Compact feature for storage.sdb (run the VACUUM command) → Compact feature for local.sqlite (executing VACUUM command)
Duplicate of this bug: 547513
Flags: wanted-calendar1.0?
You need to log in before you can comment on or make changes to this bug.