cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ricardo Sancho <sancho.rica...@gmail.com>
Subject CLUSTERING ORDER BY importance with ssd's
Date Fri, 09 Oct 2015 19:07:04 GMT
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.

Mime
View raw message