Well I'm not talking about a specific column family here, as ALL my column families will have content that is specific to a certain website, so I need a strategy that I will use on almost all my column families.
On Wed, Jul 14, 2010 at 9:20 PM, Schubert Zhang <zson...@gmail.com> wrote: > 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? >> >> >