8
83%
master: 83%

Ran 27 Apr 2020 08:14AM UTC

Files 133

Run time 11s

Badge

Embed ▾

Committed 27 Apr 2020 07:58AM UTC coverage: 81.688%. Remained the same

Job # DB=postgresql

Build Type

push

travis-ci

Committed by

web-flow

Commit Message

Tune sql (#388)

* Use compression for archives

* Make parent index only contain non-null rows for postgresql and sql server

* Lower nflow_workflow table fillfactor 100->95 to help a bit in performance with many updates. Set index fillfactors to 100 on append-only tables and all archive indices

* Swap order of workflow_uniq index to have the external_id as first item. Should help with index balance and faster lookups with external_id, which is done on every insert

* Reorder fields to miminize wasted space on padding between fields. Reduces db size aroud 7%. Also prefer setting non null fields before null fields if possible for small speed up

* No need for unique composite index on nflow_archive_workflow. Just convert it to normal index on type (which ui uses for searches)

* Add migration scripts

* fix syntax in old oracle update scripts

* drop nflow_archive_workflow_uniq from all databases

* drop nflow_archive_workflow_parent index from sqlserver in update

* Add test to verify that instance with same ext id and type can be archived multiple times

* Create index on workflow type for archive table

Co-authored-by: Edvard Fonsell <edvard.fonsell@nitorcreations.com>

Run Details

2797 of 3424 relevant lines covered (81.69%)

0.82 hits per line

NitorCreations / nflow / 4117 / 8
83%
master: 83%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 4117.8 (DB=postgresql)

NitorCreations / nflow / 4117 / 8 83% master: 83%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 4117.8 (DB=postgresql)

NitorCreations / nflow / 4117 / 8
83%
master: 83%

README BADGES
x