Forum Discussion
rdnguyen
Helper V
4 years agoAverage time of Dataflow refresh
How long in average if you setup a Dataflow loading 400K rows all 53 columns? I would like to know to compare mine (about 1.5 mins) to have an idea of baseline workload. Thanks and best regar...
- Anonymous4 years ago
Hi rdnguyen ,
Too many datasets to refresh at the same time occupy CPU and memory, Insufficient gateway or underlying data source performance (busy on network / refresh), To refresh the model to be loaded into memory, it takes up 2 times the size of the data set, and you need to wait for memory resources.
If you feel slow when refreshing, you can consider the following actions:
You can select the dataflow options (the ellipses next to the dataflow) and then select Cancel refresh. Or scheduled the refresh of dataset at different time.
Understanding and optimizing dataflows refresh
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.