Extracts are very efficient. In fact, extracts are generally faster than most live connections, except for a few extremely efficient columnar databases. This is a result of several factors, such as:
- Extracts are columnar and are extremely efficient for executing the query.
- Extracts are structured so that they can be loaded quickly into memory without additional processing and moved between memory and disk storage so the size is not limited to the amount of RAM available.
- Many calculated fields are materialized in the extract. The pre-calculated value stored in the extract can often be read faster than executing the calculation every time the query is executed.
You may choose to use the extracts to increase performance over ...