cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: "select * from A join B using(common_id) where A.id == a and B.id == b "
Date Sun, 24 Jul 2011 22:42:12 GMT
> 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


Mime
View raw message