[MAILBOX-296] Improve Expunges over Cassandra

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: cassandra
• Assignee: Unassigned
• Reporter: Benoit Tellier
• Created: 18/May/17 11:49
• Updated: 25/May/17 02:24
• Resolved: 19/May/17 10:36

Description

Large expunges are today failing on Cassandra.

And overall performance does not seem good.

We should pay attention to:

• Limiting the number of concurrent queries to avoid killing the server
• Prepare select statements in MessageDAO
• Not use IN clause in MessageDAO
• Use limit on incoming IDs on MessageDAO reads
• Better chaining of future

We will validate performance gains with gatling-imap tests.