for your apps, how about this schema: key: website1123 columnName: UserID ...
On Thu, Jul 15, 2010 at 6:13 AM, Aaron Morton <aa...@thelastpickle.com>wrote: > 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 <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? > >