Forum Discussion
Table.buffer causing weird large loading size
I currently have a table and the load refresh size is 946MB but when i add Table.buffer to the mergered query in the table to deal with an data issue that arose after i sorted and removed dublicates ...
HI Anonymous,
AFAIK, buffer function is used to the looping or custom function which will prevent invoke/reference one table with multiple times and only spend the resource at the first time. And your scenario is a simple join multiple query tables operations and it seems not required to use buffers.
Since I not so clearly the query which you used in buffer step and named #"Chiller & AHU Tasks”, can you please share some more detail about this? (Join with huge amount of records obviously will spend large amount of resources)
How to Get Your Question Answered Quickly
BTW, you can also take a look the following blog which told the improve performance methods if helps:
Speed/Performance aspects – The BIccountant
Regards,
Xiaoxin Sheng