Company
Date Published
Author
Floyd Smith
Word count
1178
Language
English
Hacker News points
None

Summary

The company, a leading industrial machinery producer, is transitioning from slow and complex data infrastructure powered by Microsoft SQL Server to SingleStore, a fully scalable relational database that supports SQL. The need for speed arose from the growing demand for analytics in their internal financial reporting application, Cadence, which was initially supported by direct SQL queries and widely used business intelligence tools. However, as the demand increased, performance became a problem, and the company tried using Microsoft SQL Server's cubes feature, but it was too slow and complex to handle. They found SingleStore through a Google search for "fastest in-memory database" and were impressed by its performance, compatibility with their existing BI tools, and operational simplicity. The company has seen 10x to 100x performance improvements compared to SQL Server and is now planning to replace other database implementations with SingleStore instances.