[
https://issues.apache.org/jira/browse/JAMES-1876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tellier Benoit closed JAMES-1876.
---------------------------------
> 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-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org
