Hi, Just got your mail from the #cassandra channel on the web chat because i couldn't get an answer...
I have a question that i'll be glad if you can help me or give me a direction. I have an activity feed like the activity feed on Instagram. When user (lets say UserA) enters his page he can see all the activities that are related to him, for example, user B liked your post.user C commented on your post etc... the cassandra data model that i thought about is: userID UDID (partition key) datetimeadded timestamp (clustering column DESC) userID_Name text userID_Picture_URL text userID_From UDID (this is userB from the example) userID_From_Name text userID_From_Picture_URL With this structure i can get the different activities to a user and it works just fine. My problem is that userID_From can change his name and his pictire and i need this data to be updated all arround the different tables because i want to show the current right values. The problem is that the update is a table scan and it's not efficient. Should i hold only the ID and every time that i select a slice of the data and get a several ID's i'll do a nother query to query about the values of the users name and picture path? Should i do something else? Best regards, Lior
