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


Mime
View raw message