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.
1
Sep 26, 2023 (2 months ago)
John
07:56 PM0.26.0.rc20-arm64
locally, compared to both 0.25.0.rc30-arm
and 0.25.2.rc1-amd64
. Queries without facet_by
go 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 Nallan
11:48 PMSep 27, 2023 (2 months ago)
Dima
08:34 AMJohn
08:55 AMgroup_by
that causes it. In general using group_by
seems to slow things down a lot, but the difference is much greater on 0.26.0.rc20Here are the numbers I get on my machine:
0.25.0.rc30-arm:
> Mean time to search with group_by=True: 56.09 ms
> Mean time to search with group_by=False: 20.17 ms
0.26.0.rc20-arm64:
> Mean time to search with group_by=True: 354.52 ms
> Mean time to search with group_by=False: 9.44 ms
Kishore Nallan
09:57 AMDima
09:58 AMKishore Nallan
10:00 AM1
Oct 05, 2023 (2 months ago)
John
08:45 PMTypesense
Indexed 3015 threads (79% resolved)
Similar Threads
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.