Uploaded image for project: 'James Server'
  1. James Server
  2. JAMES-3409

Denormalize UidValidity as part of MailboxPath projection

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 3.6.0
    • Component/s: cassandra, mailbox
    • Labels:
      None

      Description

      = 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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              btellier Benoit Tellier
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: