High-Concurrency Point Queries

On top of its analytics-oriented columnar storage, Doris provides a dedicated optimization path for online point queries and key-value lookups that demand high concurrency and low latency. Row store and the short path give Unique-table primary-key point queries high QPS and low latency. Dictionaries rewrite dimension joins into in-memory key-value lookups.

Primary-Key Point Queries

High-Concurrency Point Queries

Enable row store, the short path, and PreparedStatement on Unique primary-key tables to bring QPS and response latency for primary-key point queries to online-service levels.

Key-Value Lookups

Dictionary Acceleration

Preload dimension columns into memory and use the dict_get function in place of LEFT OUTER JOIN to significantly improve query performance in scenarios with frequent key-value lookups.