summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorYorick Peterse <yorickpeterse@gmail.com>2015-10-15 18:10:35 +0200
committerYorick Peterse <yorickpeterse@gmail.com>2015-10-15 18:10:54 +0200
commit8bfb995a59b0b909d1d27b0fc2f197999b0b837c (patch)
treeaea5b80f981c28c9ec08b3817b7b7ea2fea88c15 /db
parent5ce933599c1c1407620a340de4947497576ad12a (diff)
downloadgitlab-ce-milestone-issue-sorting-performance.tar.gz
Improve performance of sorting milestone issuesmilestone-issue-sorting-performance
This cuts down the time it takes to sort issues of a milestone by about 10x. In the previous setup the code would run a SQL query for every issue that had to be sorted. The new setup instead runs a single SQL query to update all the given issues at once. The attached benchmark used to run at around 60 iterations per second, using the new setup this hovers around 600 iterations per second. Timing wise a request to update a milestone with 40-something issues would take about 760 ms, in the new setup this only takes about 130 ms. Fixes #3066
Diffstat (limited to 'db')
0 files changed, 0 insertions, 0 deletions