Hi there! What is the best option for a large amou...
# community-helpd
Dima
03/21/2023, 8:43 PMHi there! What is the best option for a large amount of facet values (like hundreds)?
j
Jason Bosco
03/21/2023, 9:15 PMDo you mean hundreds of fields with faceting enabled in the schema, or do you mean hundreds of field in the facet_by parameter in a single search request?
d
Dima
03/21/2023, 9:17 PMIf I understand you correctly, neither one nor other. I mean
facet_countsj
Jason Bosco
03/21/2023, 9:18 PMAh I see, we call those facet values
Jason Bosco
03/21/2023, 9:18 PMHundreds of facet values is completely fine
Jason Bosco
03/21/2023, 9:20 PMWhat matters is the total number of records, across all facet values for a single search query. When the result of a search query crosses say 10M results, we’ve seen it take a few seconds to compute those facet values…
Jason Bosco
03/21/2023, 9:20 PMAre you running into any issues?
d
Dima
03/21/2023, 9:28 PMI feel uncomfortable to set up
max_facet_valuesDima
03/21/2023, 9:30 PMIf I don’t need counts, maybe I can use something like query
*entityentityj
Jason Bosco
03/21/2023, 9:41 PMYou can only fetch a max of 99 groups though
Jason Bosco
03/21/2023, 9:42 PMset up max_facet_values to a big numberThis would be the only way I can think of achieving what you’re trying to do
👀 1
Jason Bosco
03/21/2023, 9:42 PMI have a few hundred thousands of documents and each has association with entityThis should be fine
d
Dima
03/21/2023, 9:47 PMGot it, thank you
👍 1