You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "Gross, Daniel" <da...@intel.com> on 2016/04/13 02:07:45 UTC
performance question
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 = XL, price <50 USD, short-sleves, etc.
Thanks,
Daniel
---------------------------------------------------------------------
Intel Israel (74) Limited
This e-mail and any attachments may contain confidential material for
the sole use of the intended recipient(s). Any review or distribution
by others is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete all copies.
Re: performance question
Posted by Jack Krupansky <ja...@gmail.com>.
Facets can be used, and grouping of results as well, in DSE Search (Solr),
but there are a lot of different approaches that can be used, depending on
the specific user experience you require.
-- Jack Krupansky
On Tue, Apr 12, 2016 at 9:32 PM, Gross, Daniel <da...@intel.com>
wrote:
> Hi Jack,
>
>
>
> Thank you for your response.
>
>
>
> How does one deal with the taxonomy (categories) in searches like this.
>
>
>
> For example, one could enter shirt, and then add a number of criteria,
> while shirt has sub-categories of Shirts.
>
>
>
> Another issue might be a subcategory not having an attribute. How 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.krupansky@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..
>
>
>
> 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 Solr searches, including faceting.
>
>
>
> The new SASI secondary index feature in Cassandra 3.4 can be used for some
> more sophisticated searches as well, but it's not quite up to what Stratio
> and DSE Search can do.
>
>
>
>
> -- Jack Krupansky
>
>
>
> On Tue, Apr 12, 2016 at 8:07 PM, Gross, Daniel <da...@intel.com>
> wrote:
>
> 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 = XL, price <50 USD, short-sleves, etc.
>
>
>
> Thanks,
>
>
>
> Daniel
>
>
>
>
>
> ---------------------------------------------------------------------
> Intel Israel (74) Limited
>
> This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). Any review or distribution
> by others is strictly prohibited. If you are not the intended
> recipient, please contact the sender and delete all copies.
>
>
>
> ---------------------------------------------------------------------
> Intel Israel (74) Limited
>
> This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). Any review or distribution
> by others is strictly prohibited. If you are not the intended
> recipient, please contact the sender and delete all copies.
>
RE: performance question
Posted by "Gross, Daniel" <da...@intel.com>.
Hi Jack,
Thank you for your response.
How does one deal with the taxonomy (categories) in searches like this.
For example, one could enter shirt, and then add a number of criteria, while shirt has sub-categories of Shirts.
Another issue might be a subcategory not having an attribute. How 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.krupansky@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..
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 Solr searches, including faceting.
The new SASI secondary index feature in Cassandra 3.4 can be used for some more sophisticated searches as well, but it's not quite up to what Stratio and DSE Search can do.
-- Jack Krupansky
On Tue, Apr 12, 2016 at 8:07 PM, Gross, Daniel <da...@intel.com>> wrote:
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 = XL, price <50 USD, short-sleves, etc.
Thanks,
Daniel
---------------------------------------------------------------------
Intel Israel (74) Limited
This e-mail and any attachments may contain confidential material for
the sole use of the intended recipient(s). Any review or distribution
by others is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete all copies.
---------------------------------------------------------------------
Intel Israel (74) Limited
This e-mail and any attachments may contain confidential material for
the sole use of the intended recipient(s). Any review or distribution
by others is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete all copies.
Re: performance question
Posted by Jack Krupansky <ja...@gmail.com>.
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 Solr searches, including faceting.
The new SASI secondary index feature in Cassandra 3.4 can be used for some
more sophisticated searches as well, but it's not quite up to what Stratio
and DSE Search can do.
-- Jack Krupansky
On Tue, Apr 12, 2016 at 8:07 PM, Gross, Daniel <da...@intel.com>
wrote:
> 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 = XL, price <50 USD, short-sleves, etc.
>
>
>
> Thanks,
>
>
>
> Daniel
>
>
>
>
>
> ---------------------------------------------------------------------
> Intel Israel (74) Limited
>
> This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). Any review or distribution
> by others is strictly prohibited. If you are not the intended
> recipient, please contact the sender and delete all copies.
>
Re: performance question
Posted by Spencer Brown <li...@gmail.com>.
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 <da...@intel.com>
wrote:
> 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 = XL, price <50 USD, short-sleves, etc.
>
>
>
> Thanks,
>
>
>
> Daniel
>
>
>
>
>
> ---------------------------------------------------------------------
> Intel Israel (74) Limited
>
> This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). Any review or distribution
> by others is strictly prohibited. If you are not the intended
> recipient, please contact the sender and delete all copies.
>