Forum Discussion

masplin's avatar
masplin
Icon for Power Participant rankPower Participant
9 years ago
Solved

SQL vs OData very different speeds

I have a query orignally written in excel power query targetting an sql table for Microsoft Navision.  Recently I have been instructed to start using an Odata feed of the same table. The tables have ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    In general, OData is slower than SQL. Consider that you have a protocol specifically built for querying data versus a general purpose protocol being pressed into service. There is lots of overhead with HTTP and the payload of JSON coming back is a pretty verbose way of describing data and not really optimized quite honestly.

     

    In terms of Power BI Desktop, I have noticed that it is by far the fastest ingest engine out there compared with SSIS and Excel, particularly with regard to SQL.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

In general, OData is slower than SQL. Consider that you have a protocol specifically built for querying data versus a general purpose protocol being pressed into service. There is lots of overhead with HTTP and the payload of JSON coming back is a pretty verbose way of describing data and not really optimized quite honestly.

 

In terms of Power BI Desktop, I have noticed that it is by far the fastest ingest engine out there compared with SSIS and Excel, particularly with regard to SQL.