Re: Is this a good schema design to implement a social application..

2011-01-08 Thread Edward Capriolo
On Fri, Jan 7, 2011 at 11:38 PM, Rajkumar Gupta wrote: > In the twissandra example, > http://www.riptano.com/docs/0.6/data_model/twissandra#adding-friends , > I find that they have split the materialized view of a user's homepage > (like his followers list, tweets from friends) into several > colu

Re: Is this a good schema design to implement a social application..

2011-01-07 Thread Rajkumar Gupta
In the twissandra example, http://www.riptano.com/docs/0.6/data_model/twissandra#adding-friends , I find that they have split the materialized view of a user's homepage (like his followers list, tweets from friends) into several columnfamilies instead of putting in supercolumns inside a single Supe

Re: Is this a good schema design to implement a social application..

2011-01-07 Thread Rajkumar Gupta
The fact that subcolumns inside the supercolumns aren't indexed currently may suck here, whenever a small no (10-20 ) of subcolumns need to be retreived from a large list of subcolumns of a supercolumn like MyPostsIdKeysList. On Fri, Jan 7, 2011 at 9:58 PM, Raj wrote: > My question is in context

Is this a good schema design to implement a social application..

2011-01-07 Thread Raj
My question is in context of a social network schema design I am thinking of following schema for storing a user's data that is required as he logs in & is led to his homepage:- (I aimed at a schema design such that through a single row read query all the data that would be required to put up the