Forum Discussion
Solved
Improve performances for Nested.Join
Dear all, I have a two tables: Table 1, which is the main one Table 2's, i.e. a lot of subtables from where I need to recover values to make calculation in the Table 1. I am using a custom f...
Hi Mic1979
After reviewing the dataset, it was found that the file contains a large amount of data, which could impact the performance of the functions. To enhance performance, follow these steps:
- Use Direct Query or Live connection for importing data this will reduce the time and improves the query performance .
- Remove unnecessary rows or columns from tables. This will help speed up operations, especially when performing joins.
- Since you are using custom function due to this the performance will reduced. If possible, try to replace your custom function with built-in functions that are often optimized for performance.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos".
Hi Mic1979
After reviewing the dataset, it was found that the file contains a large amount of data, which could impact the performance of the functions. To enhance performance, follow these steps:
- Use Direct Query or Live connection for importing data this will reduce the time and improves the query performance .
- Remove unnecessary rows or columns from tables. This will help speed up operations, especially when performing joins.
- Since you are using custom function due to this the performance will reduced. If possible, try to replace your custom function with built-in functions that are often optimized for performance.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos".
Hi Mic1979
Hi
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.