Forum Discussion
Siboska
3 years agoHelper II
Bad 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...
- 3 years ago
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
3 years agoCommunity Champion
Siboska You can create a dataflow and in the dataflow turn on Enhanced Compute Engine.
- Siboska3 years agoHelper II
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.