Closed Bug 1669658 Opened 8 months ago Closed 8 months ago

Increase the maximum SQLite cache size for storage calendars

Categories

(Calendar :: Provider: Local Storage, enhancement)

enhancement

Tracking

(thunderbird_esr78 fixed, thunderbird82 fixed)

RESOLVED FIXED
83 Branch
Tracking Status
thunderbird_esr78 --- fixed
thunderbird82 --- fixed

People

(Reporter: darktrojan, Assigned: darktrojan)

References

Details

Attachments

(1 file)

The default cache size is 2MiB but storage calendars are frequently a lot larger than that. The whole database has to be read for many operations such as getItems. I think that increasing the limit (to 20MiB maybe) would be good for performance especially where file I/O is expensive. I haven't got any scientific evidence to support my theory (a little unscientific evidence) but I'd like to try it and see if it helps the heavy users.

See Also: → 1669661

Increases the maximum cache size to 10 MiB per connection. In practice this is unlikely to be reached except for very large calendars.

Target Milestone: --- → 83 Branch

Comment on attachment 9180329 [details]
Bug 1669658 - Increase the maximum SQLite cache size for storage calendars. r?Fallen

[Approval Request Comment]
Low risk patch, just changing the size of a cache.

Attachment #9180329 - Flags: approval-comm-esr78?
Attachment #9180329 - Flags: approval-comm-beta?

Pushed by geoff@darktrojan.net:
https://hg.mozilla.org/comm-central/rev/ca9567eb2461
Increase the maximum SQLite cache size for storage calendars. r=Fallen

Status: ASSIGNED → RESOLVED
Closed: 8 months ago
Resolution: --- → FIXED

Comment on attachment 9180329 [details]
Bug 1669658 - Increase the maximum SQLite cache size for storage calendars. r?Fallen

[Triage Comment]
Approved for beta
Approved for esr78

Attachment #9180329 - Flags: approval-comm-esr78?
Attachment #9180329 - Flags: approval-comm-esr78+
Attachment #9180329 - Flags: approval-comm-beta?
Attachment #9180329 - Flags: approval-comm-beta+
You need to log in before you can comment on or make changes to this bug.