Repo.insert!/1 benchmark

insert_bench_output.exs

Operating System: Linux
CPU Information: Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz
Number of Available Cores: 4
Available memory: 15.49 GB
Elixir 1.6.4
Erlang 20.3
Benchmark suite executing with the following configuration:
warmup: 2 s
time: 5 s
parallel: 1
inputs: Changeset, Struct
Estimated total run time: 28 s


Benchmarking MySQL Insert with input Changeset...
Benchmarking MySQL Insert with input Struct...
Benchmarking Pg Insert with input Changeset...
Benchmarking Pg Insert with input Struct...

##### With input Changeset #####
Name                   ips        average  deviation         median         99th %
Pg Insert            33.87       29.53 ms    ±75.88%       24.65 ms      173.79 ms
MySQL Insert         19.00       52.62 ms    ±49.57%       49.25 ms      298.33 ms

Comparison: 
Pg Insert            33.87
MySQL Insert         19.00 - 1.78x slower

##### With input Struct #####
Name                   ips        average  deviation         median         99th %
Pg Insert            37.09       26.96 ms    ±27.52%       24.64 ms       71.26 ms
MySQL Insert         17.64       56.68 ms    ±56.03%       49.24 ms      266.17 ms

Comparison: 
Pg Insert            37.09
MySQL Insert         17.64 - 2.10x slower