Open Bug 352976 Opened 15 years ago Updated 9 years ago
Compact feature for local
.sqlite (executing VACUUM command)
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.
See comments on similar topic in Bug 334010 and http://developer.mozilla.org/en/docs/Storage:Performance#Vacuuming_and_zero-fill
Summary: Compact feature for storage.sdb → Compact feature for storage.sdb (run the VACUUM command)
13 years ago
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)
9 years ago
You need to log in before you can comment on or make changes to this bug.