Open Bug 352976 Opened 18 years ago Updated 2 years ago

Compact feature for local.sqlite (executing VACUUM command)

Categories

(Calendar :: Provider: Local Storage, enhancement)

Product:
Calendar
Component:
Provider: Local Storage
Type:
enhancement

Tracking

(Not tracked)

People

(Reporter: omar.bajraszewski, Unassigned)

References

Details

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
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)
Flags: wanted-calendar1.0?
Severity: normal → S3
You need to log in before you can comment on or make changes to this bug.