Benoit Tellier created JAMES-3409: ------------------------------------- Summary: Denormalize UidValidity as part of MailboxPath projection Key: JAMES-3409 URL: https://issues.apache.org/jira/browse/JAMES-3409 Project: James Server Issue Type: Improvement Components: cassandra, mailbox Reporter: Benoit Tellier Fix For: 3.6.0
= Why When listing paths (IMAP LIST, JMAP Mailbox/get) the list of mailboxes is retrieved first, then each mailbox is individualy read in order to retrieve the UID_VALIDITY (part of the mailbox table but not the mailboxpath table). Given that mailbox read repairs are proposed in JAMES-3407, we can safely skip the mailbox read, if the mailboxpath table holds also the UID_VALIDITY information. = How Design a newer version of the mailboxpath table holding the UID_VALIDITY information. Design a migration to this new table model. This is exactly what https://github.com/linagora/james-project/pull/3635 proposes = Definition of done Merge that pull request -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org For additional commands, e-mail: server-dev-h...@james.apache.org