> my fall-back approach is, since A and B do not change a lot, I'll > pre-generate the join of A and B (not very large) keyed on A.id + > B.id, > then do the get(a+b)
+1 materialise views / joins you know you want ahead of time. Trade space for time. Cheers ----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 23 Jul 2011, at 10:41, Yang wrote: > this is a common pattern used in RDMS, > is there some existing idiom to do it in cassandra ? > > > if the size of "select * from A where id == a " is very large, and > similarly for B, while the join of A.id == a and B.id==b is small, > then doing a get() for both and then merging seems excessively slow. > > > my fall-back approach is, since A and B do not change a lot, I'll > pre-generate the join of A and B (not very large) keyed on A.id + > B.id, > then do the get(a+b) > > > thanks > Yang
