Sorry, I copied/pasted the question from another platform where you don't generally say hello,
So : Hello everyone, 2015-01-22 20:19 GMT+01:00 SEGALIS Morgan <msega...@gmail.com>: > I have a column family that store articles. I'll need to get those > articles from the most recent to the oldest, getting them from Country, and > of course the ability to limit the number of fetched articles. > > I though about another ColumnFamily "ArticlesByDateAndCountry" with > dynamic columns > > The Key would a mix from the 2 Char country Code (ISO 3166-1), and the > articles day's date so something like : US-20150118 or FR-20141230 -- > (XX-YYYYMMDD) > > In those Row, the column name would be the timeuuid of the article, and > the value is the article's ID. > > It would probably get a thousand of articles per day for each country. > > Let's say I want to show only 100 of the newer articles, I'll get the > today's articles, and if it does not fill the request (too few articles), > I'll check the day before that, etc... > > Is that the best practice, or does someone has a better idea for this > purpose ? > -- Morgan SEGALIS
