none
Task Timephased data RRS feed

  • Question

  • Is there a difference between the data I get querying the OData feed for task timephased data and the data I can get by directly querying the MSP_EpmTaskByDay_ODATAView view?

    I ask, because the OData feed seems EXTREMELY slow, which leads me to believe there may be some additional processing on the dataset occurring. Directly querying the view, by contrast, is quite quick.


    Bryan Slatner

    Sunday, February 19, 2017 5:03 PM

Answers

  • Hello Bryan

    My assumption is that you are querying MSP_EpmTaskByDay_ODATAView using SQL Server and thus this will be fast because the records are return from SQL engine and records are being buffered in background.   If you are reading the ODATA from a web service, then there is a lot of additional overhead when the records are returned in XML format and there is more syncing of records between the web service.


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by Bryan Slatner Monday, February 20, 2017 4:34 PM
    Monday, February 20, 2017 12:15 AM
    Moderator

All replies

  • Hello Bryan

    My assumption is that you are querying MSP_EpmTaskByDay_ODATAView using SQL Server and thus this will be fast because the records are return from SQL engine and records are being buffered in background.   If you are reading the ODATA from a web service, then there is a lot of additional overhead when the records are returned in XML format and there is more syncing of records between the web service.


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by Bryan Slatner Monday, February 20, 2017 4:34 PM
    Monday, February 20, 2017 12:15 AM
    Moderator
  • So, for the purposes of reporting, querying one vs the other wouldn't yield any real difference?

    Bryan Slatner

    Monday, February 20, 2017 2:36 AM
  • Hi Bryan,

    There shouldn't be any difference, but it depends on how MS have implemented the web service as to exactly what they expose.  If you are using an on-prem system, then you have the opportunity to query the DB directly, which is generally what I would recommend for on-prem.


    Ben Howard [MVP] | web | blog | book

    Monday, February 20, 2017 9:23 AM
    Moderator
  • Well, that's certainly what I was hoping. The SSIS job I created to pull the OData feed into a table takes 3 HOURS to run. If the data in the view is the same, that's obviously the way to go.

    Bryan Slatner

    Monday, February 20, 2017 4:35 PM