[JAMES-3627] Prepared statements for applicable flags

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: master, 3.6.0
• Fix Version/s: 3.7.0
• Component/s: cassandra, mailbox
• Labels: cassandra perf
• Assignee: Unassigned
• Reporter: Benoit Tellier
• Created: 06/Aug/21 04:30
• Updated: 16/Aug/21 02:51
• Resolved: 16/Aug/21 02:51

Description

Because we do not use the ADDALL modifier, we do not prepare statements and do a manual combinaison of ADD statements.

This result in sub-obtimal query (one ADDALL is more optimized than many ADD) and suboptimal execution (not using prepeared statments is an anti pattern)