Hi Benoit,
Following the approval of the table's design, I will start to implement
*threadtable *and start with define the table and its DAO layer. I will
come back for the deletion part feature finish the guessing threadid
feature.
Best regards,
Quan
Vào Th 4, 21 thg 7, 2021 vào lúc 18:08 bt
On 21/07/2021 18:06, Quan tran hong wrote:
> Hi Benoit,
> Thanks for your great reviews.
>
>> Or we can just do several selects, one for each mimeMessageIds.I
> personaly likely prefer this option.
>
> This will make the upper logic layer more complicated. But I agree with
> your suggestion cause
Hi Benoit,
Thanks for your great reviews.
> Or we can just do several selects, one for each mimeMessageIds.I
personaly likely prefer this option.
This will make the upper logic layer more complicated. But I agree with
your suggestion cause I would prefer balance and performance also.
> Remember
Hello quan,
Nice proposal! I think the Cassandra data model you propose is evolved
enough so that we start implementing it.
Some comments inlined...
On 21/07/2021 15:55, Quan tran hong wrote:
> Hi Benoit,
> I did have another try on this. Please have a look.
> CREATE threadtable
>
> CREATE TABLE
Hi Benoit,
I did have another try on this. Please have a look.
CREATE threadtable
CREATE TABLE ThreadTable (messageId timeuuid, threadId timeuuid, username
text, mimeMessageId text, baseSubject text, PRIMARY KEY((username,
mimemessageid), messageid));
=> Partition key: (username, mimemessageid),
Hello Quan,
On 20/07/2021 17:24, Quan tran hong wrote:
> [...]
>
> SELECT threadId FROM threadtable WHERE username = 'quan' AND baseSubject =
> 'baseSubject1' AND mimeMessageId IN ('MimeMessageID2', 'MimeMessageID3')
> LIMIT 1 ALLOW FILTERING;
ALLOW FILTERING should not be used as it will result i
Hi Benoit,
Following your suggestion, I did have some experiments today. Please have a
look.
I represent this with a few outlines so you can read it easily.
Create table
CREATE TABLE ThreadTable (messageId timeuuid, threadId timeuuid, username
text, mimeMessageId text, baseSubject text, PRIMARY KE
Hello Quan,
On 19/07/2021 17:59, Quan tran hong wrote:
> Hi,
> I am starting to implement ThreadIdGuessingAlgorithm for the distributed
> module. Because this is a breaking change and I am new to Cassandra also,
> therefore I want to have some discussion with you about how to do this.
As long as w
