Performance Degradation in Version 0.26.0.rc20-arm64
TLDR 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.
Sep 26, 2023 (2 months ago)
0.26.0.rc20-arm64locally, compared to both
0.25.2.rc1-amd64. Queries without
facet_bygo from ~50ms to ~90ms and queries with many facets go from ~150ms to ~700ms. Let me know if you need any help reproducing this (hoping you might already know what could be causing this without having to reproduce 😅 )
On another note, we would love to improve on the 150 ms response time, is that just something to accept when you have ~17 facets and
max_facet_values=100, or is there anything we can do here?
Kishore Nallan11:48 PM
Sep 27, 2023 (2 months ago)
group_bythat causes it. In general using
group_byseems to slow things down a lot, but the difference is much greater on 0.26.0.rc20
Here are the numbers I get on my machine:
> Mean time to search with group_by=True: 56.09 ms
> Mean time to search with group_by=False: 20.17 ms
> Mean time to search with group_by=True: 354.52 ms
> Mean time to search with group_by=False: 9.44 ms
Kishore Nallan09:57 AM
Kishore Nallan10:00 AM
Oct 05, 2023 (2 months ago)
Indexed 3015 threads (79% resolved)
Slow Performance of Faceted Query with Increased Fields
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.
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.
Upgrading Typesense to Solve Syntax Error
Ken encountered an issue with Typesense search enhancements on their site and Jason suggested an upgrade. They also discussed the possible downtime and finalized the process.
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.
Implementing User-Level Search Features in Typesense
Ankit asked for advice on adding user-level search features in Typesense. Jason suggested using the Join feature in `0.26.0.rc11`. Sandro inquired about testing the feature and Jason provided instructions.