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

Denormalize UidValidity as part of MailboxPath projection

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Done
    • None
    • 3.6.0
    • cassandra, mailbox
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: