Forum Discussion

Baskar's avatar
Baskar
Resident Rockstar
5 years ago

Direct Query performance Issue

Dear Team,    Need help to understand what's wrong with my model  with Direct connection ( Oracle ).   Source : Oracle  Connection Type : Direct  Table used : Team Members ( Max : 57,879Rows ) ,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Baskar,

Can you please share some more detail about the 'FE' part that spend most of the duration to process?

How to Get Your Question Answered Quickly 

In addition, have you traced the network status of remote access? It may also affect the performance if these queries are pending for network connection and delay.

Regards,

Xiaoxin Sheng

  • Baskar's avatar
    Baskar
    Resident Rockstar
    5 years ago

    How we can measure the FE timing ? in DAX studio. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI Baskar,

      FE and SE seem to mean the 'formula engine' and 'storage engine'.  Perhaps You can take a look at the following blog about the difference between the two engines:

      Formula engine and storage engine in DAX 
      Regards,

      Xiaoxin Sheng

      • Baskar's avatar
        Baskar
        Resident Rockstar
        5 years ago

        Anonymous 

        Thanks. Here my problem is FE taking more time than SE. 

        Nothing is there in my model... 

        Want to know whats went wrong here.