How to Utilize Bold BI's Database Configuration for Managing Large Data Sets
Handling large data sets, such as 10 million records or more, requires proper database configuration to ensure quick rendering and optimal performance in Bold BI. In this article, we provide a list of recommendations to help you achieve better performance when working with large data sets.
1. Indexing Data
Indexing data can improve data access speed, although it may increase storage size. We recommend indexing the data based on fields that will be used for grouping or filtering. This will help in accessing the data more quickly and efficiently.
2. Creating Data Marts/Pre-Aggregated Tables
Creating data marts or pre-aggregated tables can also enhance the performance when dealing with large data sets. You can perform pre-aggregation and extract the aggregated data using the custom query extract mode in Bold BI. For more information on connecting to extract mode via custom query mode, please refer to the following user guide document
3. Partitioning Tables
By following these recommendations, you can optimize your database configuration to handle large data sets and render them quickly in Bold BI.
Related Links
