Hi all. I am beginner in Cassandra.
I am working on Q&A project where I have to maintain a list of list for objects. For e.g. A Question can have list of Answers, and each Answer can then have list of Comments. -- As of now I have 3 tables. Questions, Answers, and Comments. I have stored UID of Answers in List<uid of answers> for question, and then each answer has List<UID of comments> in separate table. [Optionally a Comment may have replies] I do multiple queries to find the complete answers-list and then its related comments. This whole thing looks inefficient to me. -- Question: *Is there a better way to do it in Cassandra*. What can I do as far as re-designing database to have lesser queries. Best Regards, Sandeep Kalra
