james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tellier Benoit (JIRA)" <j...@apache.org>
Subject [jira] [Created] (MAILBOX-289) Irrelevant primary key for subscriptions
Date Tue, 07 Mar 2017 02:25:32 GMT
Tellier Benoit created MAILBOX-289:
--------------------------------------

             Summary: Irrelevant primary key for subscriptions
                 Key: MAILBOX-289
                 URL: https://issues.apache.org/jira/browse/MAILBOX-289
             Project: James Mailbox
          Issue Type: Improvement
          Components: cassandra
            Reporter: Tellier Benoit


We have ((mailbox) user) + index on user.

This is bad distribution as many user can have same mailbox (INBOX). We moreover always access
MBXs by user or (user, mailbox)

Thus we can switch PK to ((user) mbx).

Will have no effect on already populated tables : code can live on both schema.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

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