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

Re: performance question

2016-04-12 Thread Jack Krupansky
> > *From:* Jack 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

RE: performance question

2016-04-12 Thread Gross, Daniel
is 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

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

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

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 dean.hil...@nrel.gov 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

Re: Cassandra driver performance question...

2013-06-24 Thread Jabbar Azam
, -Tony *From:* Tony Anecito adanec...@yahoo.com *To:* user@cassandra.apache.org user@cassandra.apache.org; Tony Anecito adanec...@yahoo.com *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

Re: Cassandra driver performance question...

2013-06-24 Thread Tony Anecito
: Cassandra driver performance question... Hello tony, I couldnt reply earlier because I've been decorating over the weekend so have been a bit busy. Let me know what's happens. Out of couriosity why are you using and not a cql3 native driver? Thanks Jabbar Azam On 24 Jun 2013 00:32, Tony Anecito

Re: Cassandra driver performance question...

2013-06-24 Thread Jabbar Azam
...@gmail.com *To:* user@cassandra.apache.org *Cc:* Tony Anecito adanec...@yahoo.com *Sent:* Monday, June 24, 2013 3:26 AM *Subject:* Re: Cassandra driver performance question... Hello tony, I couldnt reply earlier because I've been decorating over the weekend so have been a bit busy. Let me

Re: Cassandra driver performance question...

2013-06-23 Thread Tony Anecito
.   Regards, -Tony From: Tony Anecito adanec...@yahoo.com To: user@cassandra.apache.org user@cassandra.apache.org; Tony Anecito adanec...@yahoo.com 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

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

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

Re: Cassandra driver performance question...

2013-06-21 Thread Tony Anecito
: Jabbar Azam aja...@gmail.com To: user@cassandra.apache.org; Tony Anecito adanec...@yahoo.com 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

Re: Cassandra driver performance question...

2013-06-21 Thread Tony Anecito
...@yahoo.com To: user@cassandra.apache.org 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

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 ch...@vcider.com wrote: Hi Jonathan, yes, when I say 'node encryption' I mean inter-Cassandra node encryption. When I say 'client encryption' I mean encrypted

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

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

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 jeremy.hanna1...@gmail.comwrote: 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

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: 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 to

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 jeremy.hanna1...@gmail.comwrote: This might be helpful:

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

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.

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

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 Brandon Williams
On Fri, Mar 26, 2010 at 3:08 PM, Scott White scottbl...@gmail.com 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 =