Make required changes for Cassandra Optimisation

samagra-comms / inbound

0 stars 15 forks source link

Closed chinmoy12c closed 6 months ago

chinmoy12c commented 10 months ago

Based on the analysis done in #93, the recommended changes need to be incorporated to optimize the speed of queries.

chinmoy12c commented 9 months ago

@chinmoy12c to attach new schema for db.

chinmoy12c commented 9 months ago

The final queries that are required to be supported are here.

[ ] According to this, querying by botuuid is an integral and basic requirement of UCI, hence botuuid should be a part of partition key.
[ ] LastXMessage need not ALLOW FILTERING. The code can perform the same operation without filtering and it should be optimized.