Query Performance
- Data immediately available for query upon ingestion
- Ad-hoc queries across billions of records in a few milliseconds
- Hyper-fast aggregations using columnar storage
- No need to downsample or pre-aggregate data
- In-memory SQL query performance thanks to parallel query processing and distributed columnar field caches
- Fully distributed query engine leveraging the power of Apache Lucene®

1M inserts per second with a CrateDB cluster of 5 standard nodes only
Learn more about the latest benchmark on CrateDB performance >

"Working with CrateDB brings positive outcomes. The ingestion and throughput have very good performance, with 1 million values/sec, the horizontal scalability where we can add as many nodes as we need and the automatic query distribution across the whole cluster"
Marko Sommarberg
Lead, Digital Strategy and Business Development at ABB

CrateDB helped ABB achieve:
1 Mill values/sec | 30k to 120k event/sec |
Data ingestion | Event retrieval |

"Thanks to CrateDB's great indexing, dedicated data types, and subsequent great performance, we could execute an event and data-driven architecture, with the performance and scalability necessary for storing time-series data over time. The SQL query syntax capability of CrateDB also played a part in achieving this great outcome, as it made it easy for the team to write good performing queries using existing know-how. CrateDB is now an integral part of our big data streaming architecture and it is delivering as promised."
Kristoffer Axelsson
Principal Solution Architect
Thomas Concrete Group


"Most of the cars in our customers' fleets are in use almost 24 hours a day, and we need to store and analyse the massive amounts of data they generate in real time. We tried a few different SQL and NoSQL databases, and CrateDB offered the best combination of high performance, scalability and ease of use."
Mark Sutheran
Founder
Clickdrive.io




"CrateDB was a better solution for our needs than any other SQL or NoSQL database we tried. It was easy to migrate code off of our legacy SQL database and onto CrateDB to immediately benefit from its data flexibility and scalable performance."
Sheriff Mohamed
Director of Architecture
GolfNow

Additional resources
CrateDB at Berlin Buzzwords 2023
When ms matter: Maximizing query performance in CrateDB
Customer interview
Redefining warehouse intelligence with CrateDB
"Our distribution centers produce a lot of sensor data and we enable our customers to take data driven decisions. CrateDB allows us to operate on any Cloud and on-prem/Edge with simplicity and stellar performance, and significant cost advantages."
Alexander Mann
Owner Connected Warehouse Architecture
TGW Logistics Group