The key structure you have should group the keys based on the website There are some differences between range queries with RP and OPP this article may help
http://ria101.wordpress.com/2010/02/22/cassandra-randompartitioner-vs-orderpreservingpartitioner/

Aaron


On 15 Jul, 2010,at 08:44 AM, S Ahmed <sahmed1020@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?