Tuning DSE Search – Indexing latency and query latency

DataStax Enterprise (DSE) offers search indexing capabilities for Apache Cassandra™ data, eliminating the need for double writes or ETL's between separate DBMS and Search clusters. The API call enables full text/fuzzy search, adhoc Lucene secondary index powered filtering, and geospatial search. Advanced tuning options are available to optimize search indexing latency and search query latency. Real-Time (RT) indexing in DSE Search provides faster indexing performance with 4.7.3, especially for the tails of the latency distribution. Monitoring tools like OpsCenter and JMX provide insights into search performance metrics, while tips such as using filter cache, partition routing, and enabling docvalues can improve query performance. DSE Search also offers unique features like query retries on node failure and distributed query routing decisions based on node health.