Improve performance of orderables fetch

Description

Our performance tests for reference data report around 7s to fetch 10k orderable. We should check whether this time can be improved further.

Take a look at the used queries and see whether they can be tweaked.

Activity

Show:
Klaudia Pałkowska
February 19, 2021, 10:10 AM

I’ve verified that Get10000OrderablesByProgram p90 was reduced from ~7s to 2-3s but unfortunately Search10000OrderablesByVersionIdentities p90 increased from ~8s to 11-13s.

Assignee

Paweł Muchowski

Reporter

Sebastian Brudziński

Story Points

5

Time tracking

0m

Time remaining

0m

Sprint

Mind the Parrot Sprint 166

Priority

Major