Thank you, I will look into that option.
On Mon, Apr 17, 2023 at 3:29 AM Bowen Song via user <
user@cassandra.apache.org> wrote:
> Using a frozen UDT for all the non-key columns is a good starting point.
> You can go a step further and use frozen UDTs for the partition keys and
> clustering keys
Using a frozen UDT for all the non-key columns is a good starting point.
You can go a step further and use frozen UDTs for the partition keys and
clustering keys too if appropriate. This alone will dramatically reduce
the number of cells per row from from 13 to 3, and save 77% of
deserialisatio
Is there something I can do to speed up the deserialisation ?
In this example I did a count query, but in reality I need the actual data.
Write pattern in this table is such that all data for a given row is
written at the same time, so I know I can use frozen udt instead of this,
making it faster,
Reading 4MB from 70k rows and 13 columns (0.91 million cells) from disk
in 120ms doesn't sound bad. That's a lots of deserialisation to do. If
you want it to be faster, you can store the number of rows elsewhere if
that's the only thing you need.
On 11/04/2023 07:13, Gil Ganz wrote:
Hey
I hav
