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.