1966
100%

Ran 27 Feb 2016 10:13PM UTC

Jobs 1

Files 58

Run time 2s

Badge

Embed ▾

pending completion

Build # 1966

Build Type

Pull #581

travis-ci

Committed by

okurz

Commit Message

Optimize comment lookup for group_result by prefetch

Same functionality as in before but faster as comments are prefetched for all
jobs in each build in each group. Obviously this could be further optimized
by prefetching comments for all jobs at once but we do not know the jobs
before iterating the builds.

Tested with a production database dump from openqa.suse.de from
2016-02-25 fetching the page 'group_overview/25'. Comparing the number of
queries for comments and the user space time.

Before: 356 @ 2.6s
After: 11 @ 1.9s

Pull Request Pull Request #581: Optimize comment lookup for group_result by prefetch

Run Details

2663 of 4319 relevant lines covered (61.66%)

42.57 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	1966.1	27 Feb 2016 10:13PM UTC	58	61.66	Travis Job 1966.1

Source Files on build 1966

Coverage	∆	File	Lines	Relevant	Covered	Missed	Hits/Line

os-autoinst / openQA / 1966
100%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 1966

os-autoinst / openQA / 1966 100%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 1966

os-autoinst / openQA / 1966
100%

README BADGES
x