#community-help

Querying E-commerce Platform Performance and max_facet_values Limit

TLDR Tugay asked about performance differences in filtering methods and limits on max_facet_values on their e-commerce platform. Kishore Nallan responded affirming single value filtering is faster and there is no limit on max_facet_values.

27mo

Join the chat

Oct 20, 2021 (27 months ago)

Photo of md5-e920cc88c8354329d64e9a0332a7e5e2

Tugay

08:52 AM

Hi everyone, we are using auto schema detection in our e-commerce platform to enable faceting and filtering on custom product attributes in this case queries also dynamically generated for each custom attributes there maybe 1 to N different query filter args. We are also considering to update our schema to use single attribute that contains all facet/filter values within single string array such as {"facets": ["category/category_name1", "brand/brand_name1", "attribute_id/attribute_name"]}.

My question is: Is there a performance difference between filtering on 10 different attributes with single value and filtering on a single attribute with 10 different values? and also is there a hard limit for max_facet_values? Kishore Nallan Jason

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

08:57 AM

1. Single value filtering will be faster than multi-valued filtering.
2. No limits on max_facet_values

Tugay

08:59 AM

Thank you! 😄

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3011 threads (79% resolved)

Join Our Community

Similar Threads

Limits for Dynamically Indexed Fields in Facets

ilia asked about limits for dynamically indexed fields in facets. Jason explained that performance is tied to the number of search results and fields defined by `facet_by`.

4mo

Handling Large Amount of Facet Values

Dima asked about handling large amounts of facet values. Jason assured that it is fine and suggested setting `max_facet_values` to a large number.

9mo

Discussions on Typesense, Collections, and Dynamic Fields

Tugay shares plans to use Typesense for their SaaS platform and asks about collection sizes and sharding. Jason clarifies Typesense's capabilities and shares a beta feature. They discuss using unique collections per customer and new improvements. Kishore Nallan and Gabe comment on threading and data protection respectively.

35mo