Improving Performance in Extract Mode in Bold BI
Bold BI offers several options to enhance performance in extract mode. These options are designed to streamline the extraction process and ensure that only necessary data is extracted, reducing the load on your system and improving overall performance.
Extracting Only Needed Fields Using Custom Query Extract Option
One of the ways to improve performance in extract mode is by extracting only the fields that are needed. This can be achieved using the custom query extract option. This option allows you to write a custom query to extract only specific fields from your data source. By limiting the data extraction to only the necessary fields, you can significantly reduce the load on your system and improve the performance of Bold BI.
Creating Aggregated Table/View in Source Server and Then Performing Extraction
Another option to improve performance in extract mode is by creating an aggregated table or view in your source server and then performing the extraction. This involves aggregating your data into a single table or view on your source server before extracting it. This reduces the amount of data that needs to be extracted and processed, which can significantly improve the performance of Bold BI.
By utilizing these options, you can optimize the performance of Bold BI in extract mode, ensuring that your data extraction processes are as efficient and effective as possible.
References
