Re: performance question

2016-04-12 Thread Spencer Brown
It tends to do very well for that. Storage and modifications are what is more expensive.. On Tue, Apr 12, 2016 at 8:07 PM, Gross, Daniel wrote: > Hi, > > > > I am new to Cassandra. > > > > I am wondering how well does Cassandra perform in e-commerce applications > that have large taxonomies for

Re: performance question

2016-04-12 Thread Jack Krupansky
ack Krupansky [mailto:jack.krupan...@gmail.com] > *Sent:* Wednesday, April 13, 2016 04:25 > *To:* user@cassandra.apache.org > *Subject:* Re: performance question > > > > Usually one would go with a search engine such as Solr or Elasticsearch > for an e-commerce product catalog query.. &

RE: performance question

2016-04-12 Thread Gross, Daniel
this usually caught. For example, sometimes we see results of searchers and additional suggestions of subset of criteria to use. Thanks, Daniel From: Jack Krupansky [mailto:jack.krupan...@gmail.com] Sent: Wednesday, April 13, 2016 04:25 To: user@cassandra.apache.org Subject: Re: performance

Re: performance question

2016-04-12 Thread Jack Krupansky
Usually one would go with a search engine such as Solr or Elasticsearch for an e-commerce product catalog query.. Ad-doc and complex queries are generally an antipattern for Cassandra, but you can use the Stratio plugin to do multi-column Lucene search or DataStax Enterprise Search to perform full

performance question

2016-04-12 Thread Gross, Daniel
Hi, I am new to Cassandra. I am wondering how well does Cassandra perform in e-commerce applications that have large taxonomies for products with many user searchable product attributes; when many concurrent users in fact submit multi criteria searchers for products: E.g. Shirt, white, size =

Re: column sort order and reversed sort performance question

2013-07-07 Thread sankalp kohli
One of the reasons of using reverse order is to skip the tombstones while doing a range query. Here is an example. * Lets say we want to read all the data which is between 10 minutes old upto 60 minute old. If the data is stored from old to new in an sstable, then we have to go over all the tombst

Re: column sort order and reversed sort performance question

2013-07-03 Thread Robert Coli
On Wed, Jul 3, 2013 at 6:02 AM, Hiller, Dean wrote: > > We loaded 5 million columns into a single row and when accessing the first 30k and last 30k columns we saw no performance difference. We tried just loading 2 rows from the beginning and end and saw no performance difference. I am sure rever

column sort order and reversed sort performance question

2013-07-03 Thread Hiller, Dean
We loaded 5 million columns into a single row and when accessing the first 30k and last 30k columns we saw no performance difference. We tried just loading 2 rows from the beginning and end and saw no performance difference. I am sure reverse sort is there for a reason though. In what context

Re: Cassandra driver performance question...

2013-06-24 Thread Jabbar Azam
ards, > -Tony > > *From:* Jabbar Azam > *To:* user@cassandra.apache.org > *Cc:* Tony Anecito > *Sent:* Monday, June 24, 2013 3:26 AM > > *Subject:* Re: Cassandra driver performance question... > > Hello tony, > I couldnt reply earlier because I've been decora

Re: Cassandra driver performance question...

2013-06-24 Thread Tony Anecito
now I am trying to get inserts to work via JDBC. Running into issues there also but I will work at it till I get them to work.   Regards, -Tony From: Jabbar Azam To: user@cassandra.apache.org Cc: Tony Anecito Sent: Monday, June 24, 2013 3:26 AM Subject: Re: Cassandra driver performance question

Re: Cassandra driver performance question...

2013-06-24 Thread Jabbar Azam
is rare I use metadata. > > Regards, > -Tony > > *From:* Tony Anecito > *To:* "user@cassandra.apache.org" ; Tony > Anecito > *Sent:* Friday, June 21, 2013 9:33 PM > *Subject:* Re: Cassandra driver performance question... > > Hi Jabbar, > >

Re: Cassandra driver performance question...

2013-06-23 Thread Tony Anecito
.   Regards, -Tony From: Tony Anecito To: "user@cassandra.apache.org" ; Tony Anecito Sent: Friday, June 21, 2013 9:33 PM Subject: Re: Cassandra driver performance question... Hi Jabbar,   I think I know what is going on. I happened accross a change mentioned by the jdbc driver

Re: Cassandra driver performance question...

2013-06-21 Thread Tony Anecito
;user@cassandra.apache.org" Sent: Friday, June 21, 2013 8:56 PM Subject: Re: Cassandra driver performance question... Thanks Jabbar,   I ran nodetool as suggested and it 0 latency for the row count I have.   I also ran cli list command for the table hit by my JDBC perparedStatement and i

Re: Cassandra driver performance question...

2013-06-21 Thread Tony Anecito
Tony From: Jabbar Azam To: user@cassandra.apache.org; Tony Anecito Sent: Friday, June 21, 2013 3:32 PM Subject: Re: Cassandra driver performance question... Hello Tony, I would guess that the first queries data  is put into the row cache and the filesystem cache. The second query gets the

Re: Cassandra driver performance question...

2013-06-21 Thread Jabbar Azam
Hello Tony, I would guess that the first queries data is put into the row cache and the filesystem cache. The second query gets the data from the row cache and or the filesystem cache so it'll be faster. If you want to make it consistently faster having a key cache will definitely help. The foll

Cassandra driver performance question...

2013-06-21 Thread Tony Anecito
Hi All, I am using jdbc driver and noticed that if I run the same query twice the second time it is much faster. I setup the row cache and column family cache and it not seem to make a difference. I am wondering how to setup cassandra such that the first query is always as fast as the second on

Re: Cassandra performance question

2012-01-24 Thread Jonathan Ellis
No argument there. Thanks for explaining what you were doing to encrypt client traffic! On Mon, Jan 23, 2012 at 10:11 PM, Chris Marino wrote: > Hi Jonathan, yes, when I say 'node encryption' I mean inter-Cassandra node > encryption. When I say 'client encryption' I mean encrypted traffic from th

Re: Cassandra performance question

2012-01-23 Thread Chris Marino
Hi Jonathan, yes, when I say 'node encryption' I mean inter-Cassandra node encryption. When I say 'client encryption' I mean encrypted traffic from the Cassandra nodes to the clients. For these benchmarks we used the stress test client load generator. We ran test with no encryption, then with 'nod

Re: Cassandra performance question

2012-01-23 Thread Jonathan Ellis
Can you elaborate on to what exactly you were testing on the Cassandra side? It sounds like what this post refers to as "node" encryption corresponds to enabling "internode_encryption: all", but I couldn't guess what your client encryption is since Cassandra doesn't support that out of the box yet

Re: Cassandra performance question

2011-12-31 Thread Dom Wong
sweet, that's pretty awesome :) On Fri, Dec 30, 2011 at 8:08 PM, Jeremy Hanna wrote: > This might be helpful: > http://techblog.netflix.com/2011/11/benchmarking-cassandra-scalability-on.html > > On Dec 30, 2011, at 1:59 PM, Dom Wong wrote: > > > Hi, could anyone tell me whether this is possible w

Re: Cassandra performance question

2011-12-30 Thread Chris Marino
We did some benchmarking as well. http://blog.vcider.com/2011/09/virtual-networks-can-run-cassandra-up-to-60-faster/ Although we were primarily interested in the networking issues CM On Fri, Dec 30, 2011 at 12:08 PM, Jeremy Hanna wrote: > This might be helpful: > http://techblog.netflix.c

Re: Cassandra performance question

2011-12-30 Thread Jeremy Hanna
This might be helpful: http://techblog.netflix.com/2011/11/benchmarking-cassandra-scalability-on.html On Dec 30, 2011, at 1:59 PM, Dom Wong wrote: > Hi, could anyone tell me whether this is possible with Cassandra using an > appropriately sized EC2 cluster. > > 100,000 clients writing 50k each

Cassandra performance question

2011-12-30 Thread Dom Wong
Hi, could anyone tell me whether this is possible with Cassandra using an appropriately sized EC2 cluster. 100,000 clients writing 50k each to their own specific row at 5 second intervals?

Re: Newbie Performance Question

2010-03-28 Thread malcolm smith
Ok - so I guess that between 1400 and 3500 inserts per second is reasonably good results -- we are going to continue working on our custom code but it seems like we need a design that uses lots of row-keys and fewer column family keys and is heavily threaded. Thanks for your help in pointing out t

Re: Newbie Performance Question

2010-03-26 Thread Scott White
Right, that's what I meant, thanks for the correction. On Fri, Mar 26, 2010 at 1:11 PM, Brandon Williams wrote: > On Fri, Mar 26, 2010 at 3:08 PM, Scott White wrote: > >> Yep I believe those are inserts per second. Take the last line: >> >> "811653,1666,250" >> >> I believe that's telling you t

Re: Newbie Performance Question

2010-03-26 Thread Brandon Williams
On Fri, Mar 26, 2010 at 3:08 PM, Scott White wrote: > Yep I believe those are inserts per second. Take the last line: > > "811653,1666,250" > > I believe that's telling you that during that 10 second interval you did > 1666 inserts but your overall insert rate is 811653/250 = 3246.612 > inserts/s

Re: Newbie Performance Question

2010-03-26 Thread Scott White
Yep I believe those are inserts per second. Take the last line: "811653,1666,250" I believe that's telling you that during that 10 second interval you did 1666 inserts but your overall insert rate is 811653/250 = 3246.612 inserts/sec. Timeouts may be due to your machine(s) being fully saturated?

Re: Newbie Performance Question

2010-03-26 Thread malcolm smith
Ok I ran the stress test with out of box settings -- 50 threads and 1M row inserts. It seems to get as high as 4400 ops per second and as low as 968. Am I reading these correctly as inserts per second? These are results below. But is also generates timeouts and failures in the python code like

Re: Newbie Performance Question

2010-03-26 Thread Brandon Williams
On Fri, Mar 26, 2010 at 10:45 AM, malcolm smith < malsm...@treehousesystems.com> wrote: > I've been getting a feel for the performance elements of Cassandra using > version 0.51. I've done similar tests on HBase before, but Cassandra has > some very appealing aspects that I would like to pursue.

Newbie Performance Question

2010-03-26 Thread malcolm smith
I've been getting a feel for the performance elements of Cassandra using version 0.51. I've done similar tests on HBase before, but Cassandra has some very appealing aspects that I would like to pursue. However I'm not seeing the what seems like the common level of performance others are seeing.