Skip to content

Instantly share code, notes, and snippets.

@tallysmartins
Last active July 3, 2018 19:38
Show Gist options
  • Save tallysmartins/48644d770a0d6d47ff40ca5b87ab86f4 to your computer and use it in GitHub Desktop.
Save tallysmartins/48644d770a0d6d47ff40ca5b87ab86f4 to your computer and use it in GitHub Desktop.
Repo.to_sql/2
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment