Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.
 

Closing runs via the API is sometimes VERY slow

Hello!

We’ve been trying to get a handle on a massive amount of “open” runs across our TestRail instance and I’ve created a Python script to do the dirty work via the TestRail API.

Some of the runs are taking an excessively long time to close (a minute or more for a single run). I’m wondering what is really going on in the database that causes some runs to close in a fraction of a second, and others to take much, much longer. Sometimes my request to close a single run will time out if it takes too long.

At the rate this is going, I will be at this for weeks or months. Any insight would be appreciated.

BTW, we’ve already investigated whether this is an issue with traffic on the API and shut down the busiest accounts while I ran the script. That didn’t have any effect on the speed of closing runs.