[MAILBOX-289] Irrelevant primary key for subscriptions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: cassandra
• Assignee: Unassigned
• Reporter: Benoit Tellier
• Created: 07/Mar/17 02:25
• Updated: 13/Mar/17 02:49
• Resolved: 13/Mar/17 02:48

Description

We have ((mailbox) user) + index on user.

This is bad distribution as many user can have same mailbox (INBOX). We moreover always access MBXs by user or (user, mailbox)

Thus we can switch PK to ((user) mbx).

Will have no effect on already populated tables : code can live on both schema.