Closed Bug 858674 Opened 12 years ago Closed 12 years ago

Tweak SQLite pragmas on mobile devices for space savings

Categories

(Core :: Storage: IndexedDB, defect)

defect
Not set
normal

Tracking

()

RESOLVED FIXED
mozilla23
blocking-b2g tef+
Tracking Status
firefox21 --- wontfix
firefox22 --- wontfix
firefox23 --- fixed
b2g18 --- fixed
b2g18-v1.0.0 --- wontfix
b2g18-v1.0.1 --- fixed

People

(Reporter: bent.mozilla, Assigned: bent.mozilla)

References

Details

(Whiteboard: [qa-])

Attachments

(2 files, 1 obsolete file)

Attached patch Patch for mozilla-central, v1 (deleted) — Splinter Review
Bug 853350 requires a bunch of engineering and product work to fully resolve. In the short term we can tweak SQLite pragmas on mobile devices to get a little more space back when we delete things from indexedDB databases. We can also get a little speed boost by leaving 0-size .sqlite-journal files on disk rather than deleting them. Attached patch requires the patches from bug 857376 to land, but that should be happening as soon as the tree reopens.
Attachment #733950 - Flags: review?(khuey)
Attached patch Patch for mozilla-b2g18, v1 (obsolete) (deleted) — Splinter Review
This is nearly identical to the m-c patch, only real difference is that page_size is hardcoded since we decided not to do anything fancy on b2g18 in bug 858674.
blocking-b2g: --- → tef?
Filed bug 858680 on figuring out a long-term solution involving full VACUUMs for indexedDB.
Given that we don't have still any progress with bug 853350 I think landing this makes sense
blocking-b2g: tef? → tef+
Status: ASSIGNED → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Target Milestone: --- → mozilla23
Your b2g18 patch is going to need updating for the Windows bustage too...
Attached patch Patch for mozilla-b2g18 (deleted) — Splinter Review
Attachment #733953 - Attachment is obsolete: true
Updated patch for mozilla-b2g18.
Keywords: checkin-needed
Whiteboard: [qa-]
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: