james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tellier Benoit (JIRA)" <server-...@james.apache.org>
Subject [jira] [Created] (JAMES-1876) Remove useless index on Cassandra subscriptions
Date Mon, 28 Nov 2016 07:40:58 GMT
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

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

View raw message