[jira] [Created] (JAMES-3109) Investigate the use of MessageSearch index for First UNSEEN Uid

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

Benoit Tellier created JAMES-3109:
-------------------------------------

             Summary: Investigate the use of MessageSearch index for First UNSEEN Uid
                 Key: JAMES-3109
                 URL: https://issues.apache.org/jira/browse/JAMES-3109
             Project: James Server
          Issue Type: New Feature
          Components: cassandra, elasticsearch, mailbox
            Reporter: Benoit Tellier


After an expunge, or once all emails are read, Cassandra issues tubstone range warnings when trying to find first unseen UID of a mailbox reading `firstUnseen` table.

Maybe using the MessageSearch index to get this information is better suited. (Directly reused in the Message mapper)

Scenario:

 - inset 2000 messages in a mailbox
 - Mark them all as Read
 - Insert 10 messages
 - SELECT all unseen 

Regarding mailboxRecent, we also encounter threshold warnings, but I'm wondering if this can be treated using the search index as the full list of values is expected (but we can try)

Furthermore relying on the search index will eventually solve coherence issue for these tables



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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