To learn more about QuestDB and to create a proof of concept, please refer to Design for performance. In addition, our Capacity planning provides a more advanced optimization guide for using QuestDB in production environment.
The below are a few concepts and SQL keywords that QuestDB leverages for optimal time series performance:
- Symbol: A data type designed for frequently used string values
- Commit lag: A guide on out-of-order data ingestion and associated configuration parameters
- SQL extensions: A guide to special QuestDB SQL keywords and syntax designed for time-series data
- Designated timestamp and Partitions: Concepts and settings relevant to partitioning tables based on time