none
OData TaskTimephasedDataSet - Timeout RRS feed

  • Question

  • Hi,

    When I use the following query to Project Online OData, the query executes in 5 seconds:

    from t in TaskTimephasedDataSet
    where t.TaskId == new Guid("772ff3ef-6ddb-e311-beb4-8056f26417c2")
    select new 
    {
    	t.ProjectId,
    	t.TaskId,
    	t.TimeByDay,
    	t.TaskCost
    }

    However, when I add an OR (||) to include other Task ID's, I Always get a Timeout error, even when I use the same ID, i.e., it does not seem to be because of the size of the data.

    The example below returns a Timeout:

    from t in TaskTimephasedDataSet
    where t.TaskId == new Guid("772ff3ef-6ddb-e311-beb4-8056f26417c2")
     || t.TaskId == new Guid("772ff3ef-6ddb-e311-beb4-8056f26417c2")
    select new 
    {
    	t.ProjectId,
    	t.TaskId,
    	t.TimeByDay,
    	t.TaskCost
    }

    Is someone experiencing performance problems with Project Online OData queries?

    Thanks in advance!

     
    Thursday, June 26, 2014 12:27 PM