1669658 - Increase the maximum SQLite cache size for storage calendars

Status: RESOLVED FIXED

(Calendar :: Provider: Local Storage, enhancement)

Description

[Geoff Lankow (:darktrojan) [OOO, back 5 Jan]]

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.

Comment 1

[Geoff Lankow (:darktrojan) [OOO, back 5 Jan]]

Attachment: Bug 1669658 - Increase the maximum SQLite cache size for storage calendars. r?Fallen

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

Comment 2

[Geoff Lankow (:darktrojan) [OOO, back 5 Jan]]

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.

Comment 3

[Pulsebot]

Pushed by [e-mail]:
https://hg.mozilla.org/comm-central/rev/ca9567eb2461
Increase the maximum SQLite cache size for storage calendars. r=Fallen

Comment 4

[Wayne Mery (:wsmwk)]

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

Comment 5

[Rob Lemley [:rjl]]

Thunderbird 82.0b3:
https://hg.mozilla.org/releases/comm-beta/rev/6e4d64b04178

Comment 6

[Rob Lemley [:rjl]]

Thunderbird 78.3.3:
https://hg.mozilla.org/releases/comm-esr78/rev/a137dde60dc5