Hi guys,
We are maintaining a system for an on-line video service. ALL users' viewing
records of every movie are stored in C*. So she/he can continue to enjoy the
movie from the last point next time. The table is designed as below:
CREATE TABLE recent (
user_name text,
vedio_id text,
position int,
last_time timestamp,
PRIMARY KEY (user_name, vedio_id)
)
It worked well before. However, the records increase every day and the last
ten items may be adequate for the business. The current model use vedio_id as
cluster key to keep a row for a movie, but as you know, the business prefer to
order by the last_time desc. If we use last_time as cluster key, there will be
many records for a singe movie and the recent one is actually desired. So how
to model that? Do you have any suggestions?
Thanks!
BRs,
BEN
