Effect of `filter_by` Efficiency on Facet Field
TLDR John inquired whether filter_by is more efficient on a facet string field. Kishore Nallan clarified there's no impact.
Sep 04, 2023 (3 months ago)
John
10:55 AMfilter_by more efficient on a string field if the field is declared to be a facet, or is there no difference?
Kishore Nallan
11:00 AMJohn
11:00 AM
Typesense
Indexed 3005 threads (79% resolved)
Similar Threads
Effect of Faceted Values on Filtering Performance
Dan asked about the impact of faceted values on filtering performance. Kishore Nallan clarified that they had no effect.
Discrepancy in Result Counts for Facet_by and Filter_by
Ivan asked why result counts varied between facet_by and filter_by. Kishore Nallan suggested checking for multiple fields with the same string, which Ivan confirmed was the issue.
Performance Issues with Adding Filters to Large Datasets
Cirdes is experiencing slower response times when adding filters to a large dataset. Jason suggests trying a different version and using a different format for filters. They also inquire about the value of the 'found' field and if removing the sort_by field improves performance. SamHendley chimes in with their own similar issues and Kishore Nallan offers to discuss solutions further in DM. krok expresses interest in the discussion. Further tests and optimizations are planned.