On Sun, Feb 6, 2011 at 10:15 AM, buddhasystem <potek...@bnl.gov> wrote: > > Hello, > > If the amount of data is _that_ small, you'll have a much easier life with > MySQL, which supports the "join" procedure -- because that's exactly what > you want to achieve. > > > asil klin wrote: >> >> Hi all, >> >> I want to procure the intersection of columns set of two rows (from 2 >> different column families). >> >> To achieve the intersection results, Can I, first retrieve all >> columns(around 300) from first row and just query by those column >> names in the second row(which contains maximum 100 000 columns) ? >> >> I am using the results during the write time & not before presentation >> to the user, so latency wont be much concern while writing. >> >> Is it the proper way to procure intersection results of two rows ? >> >> Would love to hear your comments.. >> >> >> --------- >> >> Regards, >> Asil >> >> > > -- > View this message in context: > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Finding-the-intersection-results-of-column-sets-of-two-rows-tp5997248p5997743.html > Sent from the cassandra-u...@incubator.apache.org mailing list archive at > Nabble.com. >
You can use multi-get when fetching lists of already know keys optimize your round rip time.
