Okay, so a very large number of questions, each with a very modest number of answers (generally under 5), each with a modest number of comments (generally under 5).
Now we're back to the issue of how you wish to query and access the data. -- Jack Krupansky On Tue, Mar 1, 2016 at 12:39 PM, Sandeep Kalra <sandeep.ka...@gmail.com> wrote: > I do not have limit of number of Answers or its comments. Assume it to > be clone of StackOverflow.. > > > > Best Regards, > Sandeep Kalra > > > On Tue, Mar 1, 2016 at 11:29 AM, Jack Krupansky <jack.krupan...@gmail.com> > wrote: > >> Clustering columns are your friends. >> >> But the first question is how you need to query the data. Queries drive >> data models in Cassandra. >> >> What is the cardinality of this data - how many answers per question and >> how many comments per answer? >> >> >> -- Jack Krupansky >> >> On Tue, Mar 1, 2016 at 12:23 PM, Sandeep Kalra <sandeep.ka...@gmail.com> >> wrote: >> >>> 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 >>> >>> >> >
