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.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.. 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 <daniel.gr...@intel.com<mailto:daniel.gr...@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.
