Forum Discussion
Siboska
Helper II
Helper IIBad performance when referencing main table
Hi, I have some performance issues for 5 tables in my datamodel. The tables will approximitly take around 30-40 minutes to refresh. For comparison the same table in SQL take appr. 1:30 min to e...
Hi Antriks,
Thx for your reply. Interresting approach. I have never worked with dataflow tho so my solution was to rewrtite the logic in the referenced queries, so they have theire own native query only containing the relevant information. Got a significant performance boost.
AntrikshSharma
Community Champion
Community ChampionSiboska You can create a dataflow and in the dataflow turn on Enhanced Compute Engine.
SiboskaHelper II
Helper IIHi Antriks,
Thx for your reply. Interresting approach. I have never worked with dataflow tho so my solution was to rewrtite the logic in the referenced queries, so they have theire own native query only containing the relevant information. Got a significant performance boost.