Closed Bug 1669661 Opened 8 months ago Closed 8 months ago

Increase the maximum SQLite cache size for address books

Categories

(MailNews Core :: Address Book, 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 for very large address books this is insufficient. Because we already keep an in-memory cache of cards and lists it only really matters where the database is being accessed repeatedly in a short space of time, such as when GloDa indexes a bunch of messages, or if we use the database for searching (bug 1658131). I think that increasing the limit (to 20MiB maybe) would be good for performance especially where file I/O is expensive. I did some testing and it does improve indexing and database-based search, but only for very large address books.

See Also: → 1669658

SQLite cache size can be set by the address book's cacheSize preference, in KiB.
The default is 5 MiB but this can be lowered to 1 MiB if wanted. There is no maximum size.

Target Milestone: --- → 83 Branch

Pushed by geoff@darktrojan.net:
https://hg.mozilla.org/comm-central/rev/b7e3149943b1
Increase the maximum SQLite cache size for address books. r=mkmelin

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

Comment on attachment 9180330 [details]
Bug 1669661 - Increase the maximum SQLite cache size for address books. r?mkmelin

[Approval Request Comment]
Just increases the cache size. No risk.

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

Comment on attachment 9180330 [details]
Bug 1669661 - Increase the maximum SQLite cache size for address books. r?mkmelin

[Triage Comment]
Approved for beta
Approved for esr78

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