I have a couple REST queries that are pretty much identical, asking for Tasks who's Finish date falls between two specified dates:
axios.get(_spPageContextInfo.siteAbsoluteUrl + "/_api/ProjectData/Projects(guid'" + projID + "')/Tasks?$filter=TaskFinishDate gt datetime'2017-02-01T00:00:00' and TaskFinishDate le datetime'2017-03-01T00:00:00'")
axios.get(_spPageContextInfo.siteAbsoluteUrl + "/_api/ProjectServer/projects('" + projID + "')/tasks?$filter=Finish gt datetime'2017-02-01T00:00:00' and Finish le datetime'2017-03-01T00:00:00'")
They both work, and return the same 159 tasks.
However, the query to the
ProjectData service returns in 500-600 milliseconds at the most (usually only takes 200-300), while the query to the
ProjectServer service regularly takes 55-60 full seconds.
Is it really that much slower, or should I be talking to my Sys Admin to look for something wrong in the Project Server / PWA configuration?