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
On 15 Jul, 2010,at 08:44 AM, S Ahmed <firstname.lastname@example.org> 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
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?