Slow Performance of Faceted Query with Increased Fields
TLDR John experienced slowdown in faceted queries after increasing to 1000 fields. Upgrading from 0.24.0.rcn21 to 0.24.0 improved performance. The issue was attributed to John using an ARM build on an M1 Mac.
Feb 23, 2023 (10 months ago)
Before: ~100 fields, faceting by 8 fields with
max_facet_values=100=> ~0.3 seconds
After: ~1000 fields, faceting by 8 fields with
max_facet_values=100=> ~1.5 seconds (without faceting ~0.08 seconds)
Feb 24, 2023 (10 months ago)
Kishore Nallan10:32 AM
"search_cutoff": falseso doesn’t seem like it
Kishore Nallan10:33 AM
Kishore Nallan10:34 AM
Kishore Nallan12:27 PM
0.24.1.rc4so there’s something special about the
0.24.0I’m running 😄
Kishore Nallan12:34 PM
Fast (search_time_ms=130): found=1102, out_of=5800
Slow (search_time_ms=1361): found=945, out_of=2053
Kishore Nallan12:40 PM
Kishore Nallan12:41 PM
Kishore Nallan12:51 PM
Indexed 3015 threads (79% resolved)
Production Typesense Issue with Unexpected Filter Behavior
Ankit flagged a problem with a specific filter on the production server of Typesense. After several exchanges regarding optimisation and version checks, Kishore Nallan provided latest builds to troubleshoot. The filtering within facets issue persists and potential edge cases are being investigated.
Performance Degradation in Version 0.26.0.rc20-arm64
John and Dima reported performance decrease in version `0.26.0.rc20-arm64` of software, mainly with `group_by` queries. Kishore Nallan promised to investigate the problem.
Discussing Search API Limitations and Solutions
Sidharth had problems with search API response limitations and sorting issues. Kishore Nallan suggested multi_search query and provided links for an updated version. After installation, some timeout and performance issues were encountered, partially resolved by adjusting client timeout values.
Slow, High CPU Write Operations After Collection Drop in Typesense
Himank discussed an issue in Typesense where deleting and recreating a collection led to slow write operations and high CPU usage. Kishore Nallan suggested using an alias to avoid this issue. Numerous tests and debugging was conducted as pboros contributed with local testing. Kishore Nallan aimed to start implementing a range delete and full db compaction after deletion to potentially solve the issue.
Improving System Performance and Typesense Query Efficiency
SamHendley was experiencing performance issues with Typesense's large-scale system testing and proposed several improvements. Both Jason and Kishore Nallan addressed the suggestions and corrected some misconceptions. They provided further clarification and recommended upgrades for better performance.