Skip to main content

Introduction

SQL Frames is architected to provide better performance so the UX is as fluid as possible. This section describes some of the optimizations in detail.

Below are some of the optimizations

  1. ROLLUP optimization - When computing aggregate rollups, the higher level rollups are computed from the lower level aggregates. In addition, the best possible option is selected when there are multiple options.

  2. Star Schema Join Optimization - It is common to have a single transactional table as a fact and many joins to it to resolve the name from id values of these dimensions. SQL Frames has a generic join logic that is capable of supporting all types of joins. However, it is possible to make it use a fast path algorithm for this type of star schema joins. See Star Schema Join Optimization for more.