Company
Date Published
Author
Jeremy Dorn
Word count
1292
Language
English
Hacker News points
None

Summary

In January 2024, GrowthBook 2.7 introduced significant SQL performance enhancements for Enterprise users by optimizing the way metrics are processed, building upon the Fact Tables feature added in version 2.5. These enhancements allow for shared SQL definitions across related metrics, minimizing duplicate work and reducing costs, particularly for large companies using data warehouses like BigQuery or Snowflake. With a new method that combines multiple metrics from the same Fact Table into a single query, the need for temporary tables is eliminated, enabling substantial performance gains. The system now efficiently handles complex experiment queries with potentially hundreds of columns, using CASE WHEN statements to accommodate different filters for each metric without interference. Additionally, advanced functionalities like Ratio Metrics and CUPED are now more cost-effective, facilitating a broader application without performance concerns. By transitioning from numerous narrow queries to fewer wide ones, GrowthBook achieves up to a 90% cost reduction, and potentially more with advanced metrics, thereby encouraging users to conduct more experiments and drive success through increased testing velocity.