[jira] [Resolved] (MAILBOX-289) Irrelevant primary key for subscriptions

["Tellier Benoit (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/MAILBOX-289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tellier Benoit resolved MAILBOX-289.
------------------------------------
    Resolution: Fixed

Merged with https://github.com/linagora/james-project/pull/673

> Irrelevant primary key for subscriptions
> ----------------------------------------
>
>                 Key: MAILBOX-289
>                 URL: https://issues.apache.org/jira/browse/MAILBOX-289
>             Project: James Mailbox
>          Issue Type: Improvement
>          Components: cassandra
>            Reporter: Tellier Benoit
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org