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

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

Tellier Benoit created JAMES-1876:
-------------------------------------

             Summary: 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.4#6332)

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