2

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'")

and

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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.