Company
Date Published
Author
Eric Hanson
Word count
3223
Language
English
Hacker News points
None

Summary

SingleStore's DNA is focused on performance, which was demonstrated by shattering the trillion-rows-per-second scan barrier for a single SQL query on industry-standard Intel servers in March 2023. The company has broadened its vectorized, SIMD query execution technology to star join group-by aggregate queries, resulting in ludicrously good performance improvements. This enhancement enables developers to use SingleStore to get stunning performance at concurrency levels they couldn't have dreamed of before, with a database that supports mixed workloads and runs ANSI SQL. The new algorithm uses proprietary, patent-pending methods to operate directly on compressed columnstore data formats, achieving significant speedups in star join queries, up to 101 times faster than without the new capability. This improvement is particularly beneficial for applications using star or snowflake schemas with integer surrogate keys. SingleStoreDB Self-Managed 6.7 also introduces various other performance improvements, including just-in-time compilation of queries, IN-list performance enhancements, resource governor upgrades, columnstore filter speedups, intra-cluster network compression, fast sampled rowstore scans, optimizer and statistics updates, new information_schema views for tuning, query plan warnings, and statistics views.