How can we improve the performance of the data loading when connecting to a data source with many tables

When connecting to a data source with a large number of tables in Bold BI, users may experience long loading times, causing the browser to become unresponsive. This issue can be mitigated by specifying the desired table names in the Additional Connection Parameters text box during the connection process.

Steps to Resolve Long Loading Time

1. Open the Data Source Connection Dialog:

   • Navigate to the data source connection settings in Bold BI.

2. Enter Desired Table Name:

   • In the Additional Connection Parameters text box, enter the specific table name using the following syntax:

     specifictable=tablename or currenttable=tablename 
     

     

   • This will ensure that only the specified table is retrieved and listed in the tables list, significantly reducing the loading time.

3. Connecting to Multiple Tables:

   • If multiple tables need to be connected, use the following syntax in the Additional Connection Parameters input field:

     specifictable=table1,table2 or currenttable=table1,table2
     

   • This will retrieve and list only the mentioned tables, making the loading process faster for both live mode and extract data dialog for extract mode.

Example

Single Table

To load only a single table named sales_data, enter:

specifictable=sales_data

Multiple Tables

To load multiple tables named sales_data and customer and other tables which has customer in its name like customer_info , enter:

specifictable=sales_data,customer

By following these steps, the loading time when connecting to a data source with a large number of tables can be significantly reduced, improving the overall performance and responsiveness of the browser.

Additional References

• Bold BI Documentation
• Connecting to specific table in MySQL data source

By implementing these practices, users can enhance their experience and efficiency when working with large data sources in Bold BI.