cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] Commented: (CASSANDRA-749) Secondary indices for column families
Date Tue, 13 Apr 2010 05:40:52 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12856309#action_12856309
] 

Jonathan Ellis commented on CASSANDRA-749:
------------------------------------------

Another thought: if you are reading small "pages" worth of indexed rows out at a time, which
we've been discussing here as the use case that non-local indexes are good at, then presumably
you want the rows in your pages ordered by some property.

If this property is the original, base row key (or if the user doesn't care and allows us
to pick), then local indexes are just as efficient as non-local under OPP, since you can only
query a single replica.  (Under RP, you can't do non-local indexes at all, so local indexes
still wins.)

If the property is NOT the original, base row key, then not matter what kind of index you
have, you need to read all the results to sort in the desired order, in which case parallelizing
that read is better than not, which you get for free with local indexes; the "index hot spot"
reasoning also applies.

> Secondary indices for column families
> -------------------------------------
>
>                 Key: CASSANDRA-749
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-749
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: Core
>            Reporter: Gary Dusbabek
>            Assignee: Gary Dusbabek
>            Priority: Minor
>             Fix For: 0.8
>
>         Attachments: 0001-simple-secondary-indices.patch, views-discussion-2.txt, views-discussion.txt
>
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message