incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: ColumnFamily per Index?
Date Fri, 23 Sep 2011 21:32:51 GMT
On Fri, Sep 23, 2011 at 5:28 PM, Ron Siemens <rsiemens@greatergood.com>wrote:

>
> I have a column family for my main data, and I have been using an
> additional column family to store indexes to the data: row per index style.
>
> I now want to be able to update a set of indexes by the field being indexed
> on.  To access that set, I can maintain meta indexes for each field, or I
> can switch from RP to OPP and do range queries on field-prefixed index
> names.  Both options seem less than ideal.  The first is annoying extra
> maintenance, and the second means I may open a can of worms with
> load-balancing.
>
> I concluded another option might be better with neither of those drawbacks.
>  I can just create a ColumnFamily per field being indexed.  I can now easily
> access and update the indexes for a particular field.
>
> I'm wondering if anyone has also contemplated this
> Column-Family-per-Index-Field option or is using it, and has any thoughts or
> critique regarding it.
>
> Ron
>


I am doing column family per index with casbase
https://github.com/edwardcapriolo/casbase. However if you look into
dynamic-composite columns the use case they were made for is to store
multiple indexes of different types in the same column family.

Mime
View raw message