4117
83%

Ran 27 Apr 2020 08:07AM UTC

Jobs 12

Files 133

Run time 19min

Badge

Embed ▾

pending completion

Build # 4117

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%)

9.8 hits per line

Jobs

ID	Job ID	Ran	Coverage
1	4117.1 (DB=h2)	27 Apr 2020 08:07AM UTC	81.7	Travis Job 4117.1
2	4117.2 (DB=postgresql)	27 Apr 2020 08:07AM UTC	81.7	Travis Job 4117.2
3	4117.3 (DB=mysql)	27 Apr 2020 08:07AM UTC	81.7	Travis Job 4117.3
4	4117.4 (DB=mariadb)	27 Apr 2020 08:07AM UTC	81.7	Travis Job 4117.4
5	4117.5 (DB=sqlserver)	27 Apr 2020 08:07AM UTC	81.7	Travis Job 4117.5
6	4117.6 (DB=db2)	27 Apr 2020 08:19AM UTC	81.7	Travis Job 4117.6
7	4117.7 (DB=h2)	27 Apr 2020 08:14AM UTC	81.69	Travis Job 4117.7
8	4117.8 (DB=postgresql)	27 Apr 2020 08:14AM UTC	81.69	Travis Job 4117.8
9	4117.9 (DB=mysql)	27 Apr 2020 08:15AM UTC	81.69	Travis Job 4117.9
10	4117.10 (DB=mariadb)	27 Apr 2020 08:15AM UTC	81.69	Travis Job 4117.10
11	4117.11 (DB=sqlserver)	27 Apr 2020 08:23AM UTC	81.69	Travis Job 4117.11
12	4117.12 (DB=db2)	27 Apr 2020 08:26AM UTC	81.69	Travis Job 4117.12

NitorCreations / nflow / 4117
83%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 4117

NitorCreations / nflow / 4117 83%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 4117

NitorCreations / nflow / 4117
83%

README BADGES
x