incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Multiple keyspaces vs Multiple CFs
Date Thu, 08 Nov 2012 23:14:00 GMT
Any connection pool. Imagine if you have 10 column families in 10
keyspaces. You pull a connection off the pool and the odds are 1 in 10
of it being connected to the keyspace you want. So 9 out of 10 times
you have to have a network round trip just to change the keyspace, or
you have to build a keyspace aware connection pool.
Edward

On Thu, Nov 8, 2012 at 5:36 PM, sankalp kohli <kohlisankalp@gmail.com> wrote:
> Which connection pool are you talking about?
>
>
> On Thu, Nov 8, 2012 at 2:19 PM, Edward Capriolo <edlinuxguru@gmail.com>
> wrote:
>>
>> it is better to have one keyspace unless you need to replicate the
>> keyspaces differently. The main reason for this is that changing
>> keyspaces requires an RPC operation. Having 10 keyspaces would mean
>> having 10 connection pools.
>>
>> On Thu, Nov 8, 2012 at 4:59 PM, sankalp kohli <kohlisankalp@gmail.com>
>> wrote:
>> > Is it better to have 10 Keyspaces with 10 CF in each keyspace. or 100
>> > keyspaces with 1 CF each.
>> > I am talking in terms of memory footprint.
>> > Also I would be interested to know how much better one is over other.
>> >
>> > Thanks,
>> > Sankalp
>
>

Mime
View raw message