这个cassandra paging的解决方案怎么样？# DataSciences - 数据科学
f*e
1 楼
As paging is a big issue of Cassandra. I have a strategy to page using
secondary index: Add a column "page_number" corresponding to each column you
want to sort and page, create an index on the "page_number" column or just
use it as the clustering column. The "page_number" is a good candidate for
indexing, since it has low cardinality: every entry in the same page has the
same page number. If there are 100 entries in one page, then there are 100
entries with the same page number. Thus is low cardinality. We can order the
entries according to each column and set the corresponding "page_number".
You can retrieve one page and do the corresponding sorting and send to
display. Is this a good way or not?
secondary index: Add a column "page_number" corresponding to each column you
want to sort and page, create an index on the "page_number" column or just
use it as the clustering column. The "page_number" is a good candidate for
indexing, since it has low cardinality: every entry in the same page has the
same page number. If there are 100 entries in one page, then there are 100
entries with the same page number. Thus is low cardinality. We can order the
entries according to each column and set the corresponding "page_number".
You can retrieve one page and do the corresponding sorting and send to
display. Is this a good way or not?