Given a CF like:
Articles : {
key1 : { title:"some title", body: "this is my article body...", .... },
key1 : { title:"some title", body: "this is my article body...", .... }
}
Now these articles could be for different websites e.g. www.website1.com,
www.website2.com
If I want to get the latest 10 articles for a given website, how would I
formulate my key to achieve this?
I basically need to understand how to handle multi-tenancy, b/c I will need
to do this for almost all my CF's.
I'm a little stuck here so guidance would be great!
On Thu, Jul 15, 2010 at 4:01 PM, S Ahmed <sahmed1...@gmail.com> wrote:
> Benjamin,
>
> Ah, thanks for clarifying that.
>
> key sorting is changing in .7 I believe to support a binary array?
>
> On Thu, Jul 15, 2010 at 3:26 PM, Benjamin Black <b...@b3k.us> wrote:
>
>> Keys are always sorted (in 0.6) as UTF8 strings. The CompareWith
>> applies to _columns_ within rows, _not_ to row keys.
>>
>> On Wed, Jul 14, 2010 at 1:44 PM, S Ahmed <sahmed1...@gmail.com> wrote:
>> > Where is the link that describes the various key types and their impact
>> on
>> > sorting? (I believe I read it before, can't seem to find it now).
>> > So my application supports multi-tenants, so I need the keys to
>> represent
>> > things like:
>> > website1123 + contentID
>> > or
>> > website3454 + userID
>> > And for range queries, these keys have to be grouped together obviously.
>> > What key type would be best suited for this?
>> >
>> >
>> > I might have to create a CF that maps the website and its key prefix?
>>
>
>
