If I have a table

CREATE TABLE status (
    user text,
    time timestamp,
    status text,
    PRIMARY KEY (user, time))
    WITH CLUSTERING ORDER BY (time ASC);

adapted from http://www.datastax.com/dev/blog/row-caching-in-cassandra-2-1

This means at the top of the partition the oldest date appears first.
If I am selecting a range from the bottom of the partition, does it make
much of a difference (considering I only use ssd's) if the clustering order
is ASC or DESC.
DESC would mean I would most of the time access the top of the partition.
Newest dates would be at the top.
While the current ASC means I access mostly the bottom.

Thanks.

Reply via email to