[
https://issues.apache.org/jira/browse/CASSANDRA-1472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13044839#comment-13044839
]
Jonathan Ellis commented on CASSANDRA-1472:
-------------------------------------------
Donal is referring to his mailing list thread where I point out that
read-before-update is required for ANY approach to indexes. There is no way
around that, and there is no way around it killing your performance when your
data set exceeds what you can cache. (If anything the current, CF-based
indexes are a best-case here because at least the bloom filter will avoid i/o
on inserts, as opposed to updates.)
Switching to SSDs is the only magic wand you'll find.
> Add bitmap secondary indexes
> ----------------------------
>
> Key: CASSANDRA-1472
> URL: https://issues.apache.org/jira/browse/CASSANDRA-1472
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Reporter: Stu Hood
> Assignee: Stu Hood
> Fix For: 1.0
>
> Attachments: 0.7-1472-v5.tgz, 0.7-1472-v6.tgz,
> 0001-CASSANDRA-1472-rebased-to-0.7-branch.txt,
> 0019-Rename-bugfixes-and-fileclose.txt, 1472-v3.tgz, 1472-v4.tgz,
> 1472-v5.tgz, anatomy.png, v4-bench-c32.txt
>
>
> Bitmap indexes are a very efficient structure for dealing with immutable
> data. We can take advantage of the fact that SSTables are immutable by
> attaching them directly to SSTables as a new component (supported by
> CASSANDRA-1471).
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
