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:
Aleksandra Sołtys
March 22, 2021, 7:39 AM

After adding the last changes Search10000OrderablesByVersionIdentities p90 was reduced to ~2s

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.

Done

Assignee

Paweł Muchowski

Reporter

Sebastian Brudziński