action #10976
closedaction #10960: current performance problems on o.s.d
comments on overview page are not prefetched
0%
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 |
Updated by okurz about 8 years ago
- Description updated (diff)
- Assignee set to okurz
Updated by okurz about 8 years ago
comparing slowest queries:
before:
3.31190109 seconds executed: SELECT ... FROM job_settings
1.65941405 seconds executed: SELECT ... FROM job_settings
1.23449016 seconds executed: SELECT ... FROM jobs
0.19449091 seconds executed: SELECT ... FROM jobs
after:
5.27770805 seconds executed: SELECT ... FROM comments
3.19738483 seconds executed: SELECT ... FROM job_settings
1.58430696 seconds executed: SELECT ... FROM job_settings
1.21815705 seconds executed: SELECT ... FROM jobs