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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to