Query Performance with CrateDB

CrateDB provides high-performance capabilities with query response time in milliseconds to process and analyze data efficiently. Its fully distributed query engine and columnar storage bring the following benefits:

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®

Industrial IoT, AI/ML, Energy

ABB Ability™ Genix optimizes operations and increases asset availability in industrial use cases by analyzing vast amounts of data in real-time. They use CrateDB to unlock the value of industrial data, working with advanced data analysis and data management capabilities. With a data ingestion rate of an 1 million values per second and event retrieval ranging from 30,000 to 120,000 events per second, ABB optimizes industrial efficiency and productivity.

"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

Industrial IoT, Time-series, Construction

Thomas Concrete Group is the world- leader organization in the construction industry with 150+ concrete plants and 2,100+ employees. They use CrateDB both for tracking of their delivery trucks and tracking the curing of the concrete in real-time.

"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

Geospatial tracking, Location services

Clickdrive.io tracks automotive vehicle fleets in real-time. They use CrateDB to enable storage and analysis of up to 2,000 data points per second, per car.

"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

Application backend, Telco

VoIPstudio is an award-winning VoIP phone service. They use CrateDB to manage call detail records (CDRs). MySQL had been used successfully for several years, but due to increasingly poor performance it was replaced by CrateDB.

"After a successful and problem-free implementation it became clear to us that CrateDB was the solution we were looking for. We gained better performance and new possibilities for our customers. We are going to improve and extend our cloud system using CrateDB."

Application backend, Software

The GolfNow division of the NBC Universal GolfChannel is trusted by 4 million registered golfers to search for golf courses that fit preference and budget. They use CrateDB to currently perform real-time queries of more than 300 million rows of data, hundreds of times per second.

"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

Community Day Talk

Make use of CrateDB's performance potential

November 15, 2022

how can you scale efficiently with CrateDB and achieve performant queries? You will learn how sharding & partitioning choices, along with correct data modeling can get you there. Also, discover how to monitor your cluster to avoid unpleasant surprises, as Marios shares his best practices to keep your cluster healthy at all times! Finally, you'll learn about the key factors which will allow you to deploy CrateDB to the cloud and achieve the desired performance.

Community Tutorial

Optimizing storage for historic time-series data

March 28, 2023

When dealing with time-series data, performance is crucial. Data that gets ingested should be available quickly for querying. To enable fast decision-making, analytical queries often need to return results in a fraction of a second.

Blog

Join performance to the rescue

July 24, 2023

Improve query performance in CrateDB by fine-tuning the query optimizer. Learn how to fixate the join order and enhance execution time. Find out more!

Blog

How we scaled ingestion to one million rows per second

August 2, 2023

One of CrateDB’s key strengths is scalability. With a truly distributed architecture, CrateDB serves high ingest loads while maintaining sub-second reading performance in many scenarios. In this article, we want to explore the process of scaling ingestion throughput. While scaling, one can meet a number of challenges - which is why we set ourselves the goal of scaling to an ingest throughput of 1,000,000 rows/s.

1 Mill values/sec	30k to 120k event/sec
Data ingestion	Event retrieval

Query Performance

Additional resources

CrateDB at Berlin Buzzwords 2023

On-demand workshop

Customer interview

Community Day Talk

Make use of CrateDB's performance potential

Community Tutorial

Optimizing storage for historic time-series data

Blog

Join performance to the rescue

Blog

How we scaled ingestion to one million rows per second

Need help with optimizing query performance with CrateDB?

Company

Ecosystem

Contact