[jira] [Resolved] (JAMES-1876) Remove useless index on Cassandra subscriptions

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

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

Tellier Benoit resolved JAMES-1876.
-----------------------------------
    Resolution: Fixed

Merged a few weeks ago

> Remove useless index on Cassandra subscriptions
> -----------------------------------------------
>
>                 Key: JAMES-1876
>                 URL: https://issues.apache.org/jira/browse/JAMES-1876
>             Project: James Server
>          Issue Type: Bug
>            Reporter: Tellier Benoit
>
> Subscriptions are accessed by user and optionally by  Mailbox
> Mailbox name is used as partition key.
> Hence, an Index is needed for retrieving a user subscription.
>  - This is ineficient : we could directly use user as primary key, and mailbox as a clustering key, thus not requiring additional indexes.
>  - This brakes scalability : several users can register relative path, and let's say there INBOX. Hence, data and load distribution is then broken.



--
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