Actions
action #10976
closedaction #10960: current performance problems on o.s.d
comments on overview page are not prefetched
Start date:
2016-02-28
Due date:
% Done:
0%
Estimated time:
Description
observation¶
many single queries for comments when rendering the index page or group_overview
steps to reproduce¶
see #10960
problem¶
Individual queries are costly but openQA gh#581 does not help as expected:
for url in '/tests/overview?distri=sle&version=12-SP2&build=1171&groupid=25' '/' '/group_overview/25' ; do export date=2016-02-26; time sudo -u geekotest OPENQA_CONFIG=local/stage_openqa_suse_de_${date} OPENQA_DATABASE=stage script/openqa get $url > /dev/null 2>&1 ; done 2>&1 | grep real
| state | times (s) for 'overview query', 'index', 'group_overview' |
|---|---|
| before | 2.3, 15.2, 8.6 |
| +openQA gh#581 | 2.4, 26.4, 12.5 |
Actions