Forum Discussion

masplin's avatar
masplin
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Referencing vs duplicating queries speed affect

Hi   I have a fialy complex query pulling in form multiple sql tables (one for each client) then a whole bunch of formatting and cleaning tasks.  This generates Table1.  The table contains 3 differ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi masplin 

     

    I would suggest using the second way.

     

    As for the first way, you have to import this source four times totally even if you removed unnecessary columns. It is inefficient. If your source contains amount of data, it will take some time whether it is importing or refreshing.

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi masplin 

 

I would suggest using the second way.

 

As for the first way, you have to import this source four times totally even if you removed unnecessary columns. It is inefficient. If your source contains amount of data, it will take some time whether it is importing or refreshing.