Project

General

Profile

action #10976

Updated by okurz about 8 years ago

## 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](https://github.com/os-autoinst/openQA/pull/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](https://github.com/os-autoinst/openQA/pull/581)| 2.4, 26.4, 12.5 | 

Back