Improve sort by blocking issues queries performance
On !34665 (merged) we introduced a new feature to sort issues list by number of blocks.
The query however in some cases is over the acceptable time limit of 100ms even using indexes. The problem is that the ordering
can happen on projects issues list and group issues list which produces different queries. For now the ordering on
project issues list is a bit slower because it does not match the index.
Here we can keep track of its performance and discuss about creating more specialized indexes for each specific case. For more information check the following discussion: !34665 (comment 395164936).
Edited by Felipe Artur