incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tyler Hobbs <ty...@riptano.com>
Subject Re: Secondary indexes change everything?
Date Thu, 09 Dec 2010 17:41:02 GMT
OPP is not yet obsolete.

The included secondary indexes still aren't good at finding keys for ranges
of indexed values, such as " name > 'b' and name < 'c' ".  This is something
that an OPP index would be good at.  Of course, you can do something similar
with one or more rows, so it's not that big of an advantage for OPP.

If you can make primary indexes useful, you might as well -- no reason to
throw that away.

The main thing that the secondary index support does is relieve you from
having to write all of the indexing code and CFs by hand.

- Tyler

On Thu, Dec 9, 2010 at 8:23 AM, David Boxenhorn <david@lookin2.com> wrote:

> - OPP becomes obsolete (OOP is not obsolete!)
> - primary indexes become obsolete if you ever want to do a range query
> (which you probably will...), better to assign a random row id
>
> Taken together, it's likely that very little will remain of your old
> database schema...
>
> Am I right?
>
>

Mime
View raw message