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".
You can use Table.Buffer to improve the performance
Hello,
on what table and on what step of the query?
And additionally, what is the better Bufer.Mode to be used? In some cases I saw my performances got worst with Table.Buffer.
Thanks.
