Re: keyspace with hundreds of columnfamilies

2014-07-14 Thread Ilya Sviridov
gt;> >> IOW, this is considered an anti-pattern, but... >> >> -- Jack Krupansky >> >> *From:* tommaso barbugli >> *Sent:* Wednesday, July 2, 2014 2:16 PM >> *To:* user@cassandra.apache.org >> *Subject:* Re: keyspace with hundreds of columnfamilies

Re: keyspace with hundreds of columnfamilies

2014-07-13 Thread Jack Krupansky
PM To: user@cassandra.apache.org Subject: Re: keyspace with hundreds of columnfamilies hi Jack thank you for your clear answer! On Saturday, 12 July 2014, Jack Krupansky wrote: 1. What does your data look like – 100 small integers or short strings and dates, or... 100 massive blobs? it will

Re: keyspace with hundreds of columnfamilies

2014-07-12 Thread tommaso barbugli
st scared that i will get into some bad situation problem when 1k CFs will grow to 5 or 10k > > -- Jack Krupansky > > *From:* tommaso barbugli > > *Sent:* Saturday, July 12, 2014 7:58 AM > *To:* user@cassandra.apache.org > > *Subject:* Re: keyspace with hundreds

Re: keyspace with hundreds of columnfamilies

2014-07-12 Thread Jack Krupansky
7:58 AM To: user@cassandra.apache.org Subject: Re: keyspace with hundreds of columnfamilies hi, how is a table with hundreds columns is going to perform? i am moving from 1k column families each with 10 columns to 100 CFs each with 100 columns. thank you tommaso On Friday, 11 July 2014

Re: keyspace with hundreds of columnfamilies

2014-07-12 Thread tommaso barbugli
e columns (e.g. time series). >>>> So 100 columns is OK. >>>> >>>> Best, >>>> Romain >>>> >>>> >>>> >>>> tommaso barbugli >>> > a écrit sur >>>> 03/07/2014 21:55:18 : >>>>

Re: keyspace with hundreds of columnfamilies

2014-07-10 Thread Sourabh Agrawal
So 100 columns is OK. >>> >>> Best, >>> Romain >>> >>> >>> >>> tommaso barbugli a écrit sur 03/07/2014 21:55:18 : >>> >>> > De : tommaso barbugli >>> > A : user@cassandra.apache.org, >>> > D

Re: keyspace with hundreds of columnfamilies

2014-07-05 Thread tommaso barbugli
gt; De : tommaso barbugli >> > A : user@cassandra.apache.org, >> > Date : 03/07/2014 21:55 >> > Objet : Re: keyspace with hundreds of columnfamilies >> > >> > thank you for the replies; I am rethinking the schema design, one >> > possible solution i

Re: keyspace with hundreds of columnfamilies

2014-07-04 Thread Jens Rantil
main > > > > tommaso barbugli a écrit sur 03/07/2014 21:55:18 : > > > De : tommaso barbugli > > A : user@cassandra.apache.org, > > Date : 03/07/2014 21:55 > > Objet : Re: keyspace with hundreds of columnfamilies > > > > thank you for the repl

Re: keyspace with hundreds of columnfamilies

2014-07-04 Thread Romain HARDOUIN
Cassandra can handle many more columns (e.g. time series). So 100 columns is OK. Best, Romain tommaso barbugli a écrit sur 03/07/2014 21:55:18 : > De : tommaso barbugli > A : user@cassandra.apache.org, > Date : 03/07/2014 21:55 > Objet : Re: keyspace with hundreds of co

Re: keyspace with hundreds of columnfamilies

2014-07-03 Thread tommaso barbugli
sky > > *From:* tommaso barbugli > *Sent:* Wednesday, July 2, 2014 2:16 PM > *To:* user@cassandra.apache.org > *Subject:* Re: keyspace with hundreds of columnfamilies > > Hi, > thank you for you replies on this; regarding the arena memory is this a > fixed memor

Re: keyspace with hundreds of columnfamilies

2014-07-02 Thread Jack Krupansky
user@cassandra.apache.org Subject: Re: keyspace with hundreds of columnfamilies Hi, thank you for you replies on this; regarding the arena memory is this a fixed memory allocation or is some sort of in memory caching? I ask because I think that a substantial portion of the column families created will n

Re: keyspace with hundreds of columnfamilies

2014-07-02 Thread tommaso barbugli
ot intended to be tweaked so it might not be a good idea to > change it. > > Best, > Romain > > tommaso barbugli a écrit sur 02/07/2014 17:40:18 : > > > De : tommaso barbugli > > A : user@cassandra.apache.org, > > Date : 02/07/2014 17:40 > > Objet

Re: keyspace with hundreds of columnfamilies

2014-07-02 Thread Romain HARDOUIN
écrit sur 02/07/2014 17:40:18 : > De : tommaso barbugli > A : user@cassandra.apache.org, > Date : 02/07/2014 17:40 > Objet : Re: keyspace with hundreds of columnfamilies > > 1MB per column family sounds pretty bad to me; is this something I > can tweak/workaround some

Re: keyspace with hundreds of columnfamilies

2014-07-02 Thread tommaso barbugli
t; > Date : 02/07/2014 10:14 > > Objet : keyspace with hundreds of columnfamilies > > > > Hi, > > Are there any known issues, shortcomings about organising data in > > hundreds of column families? > > At this present I am running with 300 column fami

RE: keyspace with hundreds of columnfamilies

2014-07-02 Thread Romain HARDOUIN
:41 : > De : tommaso barbugli > A : user@cassandra.apache.org, > Date : 02/07/2014 10:14 > Objet : keyspace with hundreds of columnfamilies > > Hi, > Are there any known issues, shortcomings about organising data in > hundreds of column families? > At this present I

Re: keyspace with hundreds of columnfamilies

2014-07-02 Thread tommaso barbugli
Hi, I am building a sort of db as a service (more, one db table as a service) and I want every user to have their own storage as much isolated as possible (and give them some freedom in terms of schema customisation and the ability to build 2i indexes). You know what kind of memory cost we are talk

Re: keyspace with hundreds of columnfamilies

2014-07-02 Thread Jonathan Lacefield
Hello There is overhead for memory with each col family. This type of configuration could cause heap issues. What is driving the requirement for so many Cfs? > On Jul 2, 2014, at 4:14 AM, tommaso barbugli wrote: > > Hi, > Are there any known issues, shortcomings about organising data in hundr

keyspace with hundreds of columnfamilies

2014-07-02 Thread tommaso barbugli
Hi, Are there any known issues, shortcomings about organising data in hundreds of column families? At this present I am running with 300 column families but I expect that to get to a couple of thousands. Is this something discouraged / unsupported (I am using Cassandra 2.0). Thanks Tommaso