Hi Everyone,
Could you please help me in modeling my table
below.I'm stuck here. My Partition key is agent_id and clustering column is
rowid. Each agent can have a minimum of 1000 rows to 10M depends on how
busy the agent .I'm facing large partition issue for my busy agents.
I'm using SizeTieredCompaction here..The table has Writes/Reads (70/30
ratio) and have deletes also in the table by agentid.
CREATE TABLE IF NOT EXISTS XXX (
agent_id UUID,
row_id BIGINT,
path TEXT,
security_attributes TEXT,
actor TEXT,
PRIMARY KEY (agent_id,row_id)
)
