Raphaël Ouazana created MAILBOX-306: ---------------------------------------
Summary: [Cassandra] Populate the attachmentId -> messageIds table Key: MAILBOX-306 URL: https://issues.apache.org/jira/browse/MAILBOX-306 Project: James Mailbox Issue Type: Improvement Reporter: Raphaël Ouazana MAILBOX-305 introduced an attachmentId -> messageIds table. We now need to migrate data to it. The plan : - (Migration optimisation) compact messageV2 table. - SELECT * on messageV2 with high timeout value (several hours?) to get the msgId -> attIds relation. Reducing the page size can also help avoid errors (maybe ~ 100) - For each entry, write to the new table. - Compact new table once finished. Tips: ensure no concurrency on writes (sequential). It's fast enough and reduce drasticly the risk to overwhelm the cluster. -- This message was sent by Atlassian JIRA (v6.4.14#64029) --------------------------------------------------------------------- To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org For additional commands, e-mail: server-dev-h...@james.apache.org