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 <kohlisank...@gmail.com> wrote: > Which connection pool are you talking about? > > > On Thu, Nov 8, 2012 at 2:19 PM, Edward Capriolo <edlinuxg...@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 <kohlisank...@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 > >
