Slow Performance on TestCase Object - API

Products

• Rally SaaS

Issue/Introduction

Most objects download content very quickly.  Even the largest objects complete in 5-7 minutes.  However, the TestCase object takes over 2 hours to complete.  I’ve run it twice and it has completed successfully both times (return ~55K records each time), but why does this one object take so much longer than all the others?  

 

Resolution

• General query slowness for this endpoint (TestCase) - Root cause
  • The reason the query for TestCase runs so long is that it is built as a collection of another artifact (e.g., User Story, Defect).  They are never built without being attached to an artifact.  So, when we query for test cases we query for all artifacts in the project that have a test case collection and THEN search that collection. 
  • For other endpoints (like Defect etc...) we search only for Defects in a Workspace and don't search for artifacts with TestCases collections THEN search the collections we find.  It's more than double the work so it takes way more time.  
• You can try the following to see if this help to speed up this query if the run time is an issue for you: 
  • Run the query during off-peak hours
  • Maybe you can limit the number of projects you run this for (no test projects etc...)?
  • Try removing the creation date query to see if that speeds things up.  You will get things from all time, the query just won't have to check for it.  You can then sort the data once is it retrieved.