cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guy Incognito <dnd1...@gmail.com>
Subject Re: Schema advice/help
Date Tue, 27 Mar 2012 08:10:04 GMT
without the ability to do disjoint column slices, i would probably use 5 
different rows.

userId:itemType -> activityId

then it's a multiget slice of 10 items from each of your 5 rows.

On 26/03/2012 22:16, Ertio Lew wrote:
> I need to store activities by each user, on 5 items types. I always 
> want to read last 10 activities on each item type, by a user (ie, 
> total activities to read at a time =50).
>
> I am wanting to store these activities in a single row for each user 
> so that they can be retrieved in single row query, since I want to 
> read all the last 10 activities on each item.. I am thinking of 
> creating composite names appending "itemtype" : 
> "activityId"(activityId is just timestamp value) but then, I don't see 
> about how to read the last 10 activities from all itemtypes.
>
> Any ideas about schema to do this better way ?


Mime
View raw message