Repo.to_sql/2

to_sql_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: 40 s
parallel: 1
inputs: Complex Query 2 Joins, Complex Query 4 Joins, Fetch First Registry, Fetch Last Registry, Ordinary Delete All, Ordinary Order By, Ordinary Select All, Ordinary Update All, Ordinary Where
Estimated total run time: 12.60 min


Benchmarking MySQL Query Builder with input Complex Query 2 Joins...
Benchmarking MySQL Query Builder with input Complex Query 4 Joins...
Benchmarking MySQL Query Builder with input Fetch First Registry...
Benchmarking MySQL Query Builder with input Fetch Last Registry...
Benchmarking MySQL Query Builder with input Ordinary Delete All...
Benchmarking MySQL Query Builder with input Ordinary Order By...
Benchmarking MySQL Query Builder with input Ordinary Select All...
Benchmarking MySQL Query Builder with input Ordinary Update All...
Benchmarking MySQL Query Builder with input Ordinary Where...
Benchmarking Pg Query Builder with input Complex Query 2 Joins...
Benchmarking Pg Query Builder with input Complex Query 4 Joins...
Benchmarking Pg Query Builder with input Fetch First Registry...
Benchmarking Pg Query Builder with input Fetch Last Registry...
Benchmarking Pg Query Builder with input Ordinary Delete All...
Benchmarking Pg Query Builder with input Ordinary Order By...
Benchmarking Pg Query Builder with input Ordinary Select All...
Benchmarking Pg Query Builder with input Ordinary Update All...
Benchmarking Pg Query Builder with input Ordinary Where...

##### With input Complex Query 2 Joins #####
Name                          ips        average  deviation         median         99th %
MySQL Query Builder       80.92 K       12.36 μs   ±352.67%          11 μs          16 μs
Pg Query Builder          80.27 K       12.46 μs   ±377.08%          11 μs          17 μs

Comparison: 
MySQL Query Builder       80.92 K
Pg Query Builder          80.27 K - 1.01x slower

##### With input Complex Query 4 Joins #####
Name                          ips        average  deviation         median         99th %
MySQL Query Builder       74.05 K       13.50 μs   ±313.70%          12 μs          18 μs
Pg Query Builder          72.71 K       13.75 μs   ±334.56%          12 μs          21 μs

Comparison: 
MySQL Query Builder       74.05 K
Pg Query Builder          72.71 K - 1.02x slower

##### With input Fetch First Registry #####
Name                          ips        average  deviation         median         99th %
MySQL Query Builder      120.20 K        8.32 μs   ±674.23%           7 μs          11 μs
Pg Query Builder         120.09 K        8.33 μs   ±687.83%           7 μs          11 μs

Comparison: 
MySQL Query Builder      120.20 K
Pg Query Builder         120.09 K - 1.00x slower

##### With input Fetch Last Registry #####
Name                          ips        average  deviation         median         99th %
Pg Query Builder         120.58 K        8.29 μs   ±653.33%           7 μs          11 μs
MySQL Query Builder      120.55 K        8.30 μs   ±661.27%           7 μs          11 μs

Comparison: 
Pg Query Builder         120.58 K
MySQL Query Builder      120.55 K - 1.00x slower

##### With input Ordinary Delete All #####
Name                          ips        average  deviation         median         99th %
Pg Query Builder         165.49 K        6.04 μs   ±973.56%           5 μs           8 μs
MySQL Query Builder      163.50 K        6.12 μs   ±912.59%           5 μs           8 μs

Comparison: 
Pg Query Builder         165.49 K
MySQL Query Builder      163.50 K - 1.01x slower

##### With input Ordinary Order By #####
Name                          ips        average  deviation         median         99th %
MySQL Query Builder      122.12 K        8.19 μs   ±591.00%           7 μs          10 μs
Pg Query Builder         119.13 K        8.39 μs   ±670.76%           7 μs          12 μs

Comparison: 
MySQL Query Builder      122.12 K
Pg Query Builder         119.13 K - 1.03x slower

##### With input Ordinary Select All #####
Name                          ips        average  deviation         median         99th %
MySQL Query Builder      140.55 K        7.11 μs   ±804.84%           6 μs           9 μs
Pg Query Builder         140.14 K        7.14 μs   ±737.02%           6 μs           9 μs

Comparison: 
MySQL Query Builder      140.55 K
Pg Query Builder         140.14 K - 1.00x slower

##### With input Ordinary Update All #####
Name                          ips        average  deviation         median         99th %
MySQL Query Builder      133.54 K        7.49 μs   ±755.04%           6 μs          10 μs
Pg Query Builder         131.69 K        7.59 μs   ±720.85%           6 μs           9 μs

Comparison: 
MySQL Query Builder      133.54 K
Pg Query Builder         131.69 K - 1.01x slower

##### With input Ordinary Where #####
Name                          ips        average  deviation         median         99th %
MySQL Query Builder      115.45 K        8.66 μs   ±572.77%           7 μs          11 μs
Pg Query Builder         112.53 K        8.89 μs   ±549.06%           8 μs          12 μs

Comparison: 
MySQL Query Builder      115.45 K
Pg Query Builder         112.53 K - 1.03x slower