Querying builds with the REST API, performance
Hi,
I have a performance problem with the following query:
https://teamcity/httpAuth/app/rest/builds/?locator=pinned:true,branch:default:any&count=100000
It takes between 2s 30s, and even in extreme cases 150s (we have about 100000 builds, the query returns about 1500 of them). I have 2 questions:
- are the results cached ? That would explain the differences in execution time
- is there more performant way to perform this query?
Cheers,
Olivier
Please sign in to leave a comment.
Hi Olivier,
No, the resulst are not cached. Often the most slow part of the REST request is authentication. Please watch/vote for the feature request and consider the approach to reuse authentication cookie.
OK, thanks, I will try it out.