Skip to content

Instantly share code, notes, and snippets.

@aronasorman
Last active July 23, 2017 00:26
Show Gist options
  • Save aronasorman/47217abcf52a6f7b548b9b98ae5f4fe7 to your computer and use it in GitHub Desktop.
Save aronasorman/47217abcf52a6f7b548b9b98ae5f4fe7 to your computer and use it in GitHub Desktop.

Without PRAGMAs:

all scenarios completed
Complete report @ 2017-07-22T00:21:45.560Z
  Scenarios launched:  50
  Scenarios completed: 50
  Requests completed:  100
  RPS sent: 1.03
  Request latency:
    min: 5654.4
    max: 70442.7
    median: 30630.7
    p95: 66491
    p99: 69644.8
  Scenario duration:
    min: 38275.4
    max: 88952
    median: 65246.8
    p95: 87776.5
    p99: 88952
  Scenario counts:
    Log in and learn: 50 (100%)
  Codes:
    200: 50
    201: 50

With PRAGMAs:

all scenarios completed
Complete report @ 2017-07-22T00:15:24.728Z
  Scenarios launched:  50
  Scenarios completed: 50
  Requests completed:  100
  RPS sent: 1.06
  Request latency:
    min: 5203
    max: 69055.7
    median: 28081.7
    p95: 65293
    p99: 68102.2
  Scenario duration:
    min: 36256.4
    max: 86266.5
    median: 63712.6
    p95: 85406.1
    p99: 86266.5
  Scenario counts:
    Log in and learn: 50 (100%)
  Codes:
    200: 50
    201: 50

Without PRAGMAS, with separate session DB:

all scenarios completed
Complete report @ 2017-07-22T00:38:16.248Z
  Scenarios launched:  50
  Scenarios completed: 50
  Requests completed:  100
  RPS sent: 0.81
  Request latency:
    min: 4394.7
    max: 91201.4
    median: 19370.3
    p95: 82047.5
    p99: 89438.4
  Scenario duration:
    min: 17377.4
    max: 116574.5
    median: 55834.8
    p95: 109818.2
    p99: 116574.5
  Scenario counts:
    Log in and learn: 50 (100%)
  Codes:
    200: 14
    201: 43
    400: 1
    500: 42

With WAL file PRAGMA:

all scenarios completed
Complete report @ 2017-07-23T00:24:17.327Z
  Scenarios launched:  50
  Scenarios completed: 50
  Requests completed:  100
  RPS sent: 1.22
  Request latency:
    min: 792.8
    max: 53132.4
    median: 27819.3
    p95: 51644.8
    p99: 52591.1
  Scenario duration:
    min: 20309.4
    max: 72850.6
    median: 53226
    p95: 72487.6
    p99: 72850.6
  Scenario counts:
    Log in and learn: 50 (100%)
  Codes:
    200: 50
    201: 50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment