Hi everyone,
I’m running a website focused on CapCut tutorials and resources, and I’ve implemented Elasticsearch for powering the search functionality. However, I’m experiencing significant performance issues:
- Slow Search Queries: Some search queries, especially those involving multiple filters (e.g., tutorial type, video duration, and keywords like "CapCut tutorial" or "editing tips"), are taking several seconds to return results.
- High Resource Usage: My Elasticsearch node frequently spikes in CPU and memory usage, even with a relatively small dataset (around 50,000 documents).
- Relevance Issues: The search results often don’t rank the most relevant tutorials or resources at the top, despite fine-tuning the query using
boost
andmatch
settings.
Here’s my setup:
- Elasticsearch version: 8.10
- Hosting environment: AWS EC2 with 4 vCPUs and 16GB RAM
- Index size: ~50MB
- Query structure: Combines
match
andterm
queries with aggregations for filtering.
I’ve tried optimizing the index by reducing unnecessary fields and increasing the refresh_interval
, but the performance hasn’t improved much. If you’re exploring tools or resources for CapCut pro, click here to find an excellent option for downloading the app and its modified features. Has anyone faced similar issues with Elasticsearch on a moderately sized website? Any advice on query optimization, hardware scaling, or alternative approaches for improving relevance would be greatly appreciated!
Thanks in advance!