Benoit Tellier created JAMES-4225:
-------------------------------------
Summary: Cassandra schema cleanup ahead of 3.10
Key: JAMES-4225
URL: https://issues.apache.org/jira/browse/JAMES-4225
Project: James Server
Issue Type: Improvement
Components: cassandra, mailbox
Reporter: Benoit Tellier
-> we can drop messagev3.bodystartoctet
Only written never read and that is a simple arithmetic computation of 2 other
data of the table. 8 bytes per message saved...
-> migration of
{code:java}
.withColumn(CassandraMessageV3Table.INTERNAL_DATE, TIMESTAMP)
.withColumn(CassandraMessageV3Table.BODY_START_OCTET, INT)
.withColumn(CassandraMessageV3Table.FULL_CONTENT_OCTETS, BIGINT)
.withColumn(CassandraMessageV3Table.HEADER_CONTENT, TEXT))
{code}
as never been done (3.7.0) later null value support was added (3.8.0) yet those
columns needlessly appear in messagev3
After 3.10.0 we can drop those!
Remember that we can also address deletion data races in imapUidTable by basing
content cleanup on internalDate.
Cassandra path can then be reworked assuming that imapuidtable or
messageidtable are complete, and messagev3 columns dropped
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
