os-autoinst / openQA / 1968

100%

Pull #582

travis-ci

Skip job groups in _group_result when starting with '~'

As of 2016-02-26 we encountered a major performance regression on
openqa.suse.de as for yet unknown reason many more jobs than in before are
considered for parsing the group results on the index page and group overview
pages in specific job groups.

As more than 20k jobs are fetched from the database the query itself for job
settings is slow as well as the subsequent processing in
OpenQA::WebAPI::Controller::Main::_group_result.

This is a workaround to skip the parsing of job groups if they start with a
'~'. This way "special job groups" can be renamed accordingly to ensure
acceptable performance.

Performance was measured retrieving the index page with a database dump from
openqa.suse.de from 2016-02-26 with the command:
    export date=2016-02-26; time sudo -u geekotest \
    OPENQA_CONFIG=local/stage_openqa_suse_de_2016-02-26 \
    OPENQA_DATABASE=stage script/openqa get / > /dev/null 2>&1

Performance results:
 - before: 15.4s
 - after: 2.3s

Related issue: https://progress.opensuse.org/issues/10960

4 of 4 new or added lines in 1 file covered. (100.0%)

2660 of 4318 relevant lines covered (61.6%)

42.52 hits per line