Custom Connector Navigator Performance Issues

[zua]

Hello, 

I implement a custom connector to get a connection to a special database. 

Could you help me with performance issues when using the navigator? 

I have built a 2 dimensional navigation table (schemas and tables/views).

But if I click "content" to lock at the schemas the loading time is high (> 2 minutes) and is dependent on the count of schemas and tables. 

How can I speed up the loading process in the navigator?  

Is it possible to prevent my functions that build the navigation table for each schema from running when click on "content"?

So the content of the navigation table under TEST_HDI_DB_1 is loaded only if the user clicks on this schema.

Or do you have any other ideas how to speed up the loading?

Thank you very much! 

[Anonymous · Accepted solution]

Hi @zua 

Based on your description, you can consider to optimize your data model. such as
1.remove columns that are not necessary

2.If you have large dataset, you can consider to use Table.Buffer() function to cache the data to improve the performance, you can refer to the following link about the function.

Table.Buffer - PowerQuery M | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.