[ https://issues.apache.org/jira/browse/CASSANDRA-6066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14084607#comment-14084607 ]
Lyuben Todorov commented on CASSANDRA-6066: ------------------------------------------- bq. We should perform more aggressive paging over the index partition [~iamaleksey] Can you elaborate a bit? As for fetching the rows from the base cf (and it's tables), as far as i can see a good starting point would be to try to work out if the list of {{SecondaryIndexSearcher}}s can be narrowed down to a single search (im talking about SecondaryIndexManager#search}}). > LHF 2i performance improvements > ------------------------------- > > Key: CASSANDRA-6066 > URL: https://issues.apache.org/jira/browse/CASSANDRA-6066 > Project: Cassandra > Issue Type: Improvement > Reporter: Aleksey Yeschenko > Assignee: Lyuben Todorov > Labels: performance > Fix For: 2.1.1 > > > We should perform more aggressive paging over the index partition (costs us > nothing) and also fetch the rows from the base table in one slice query (at > least the ones belonging to the same partition). -- This message was sent by Atlassian JIRA (v6.2#6252)