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.