Skip to content

Instantly share code, notes, and snippets.

@tallysmartins

tallysmartins/load_bench_output.exs

Last active July 3, 2018 19:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tallysmartins/6ceb5b62369c80e604287b263abcc0d8 to your computer and use it in GitHub Desktop.
Save tallysmartins/6ceb5b62369c80e604287b263abcc0d8 to your computer and use it in GitHub Desktop.
Download ZIP
Repo.load/2 benchmark
Raw
load_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: 10 s
parallel: 1
inputs: Big 1 Million, Date attr, Large 5 Million, Medium 100 Thousand, NaiveDateTime attr, Small 1 Thousand, Time attr, UUID attr
Estimated total run time: 3.20 min
Benchmarking MySQL Loader with input Big 1 Million...
Benchmarking MySQL Loader with input Date attr...
Benchmarking MySQL Loader with input Large 5 Million...
Benchmarking MySQL Loader with input Medium 100 Thousand...
Benchmarking MySQL Loader with input NaiveDateTime attr...
Benchmarking MySQL Loader with input Small 1 Thousand...
Benchmarking MySQL Loader with input Time attr...
Benchmarking MySQL Loader with input UUID attr...
Benchmarking Pg Loader with input Big 1 Million...
Benchmarking Pg Loader with input Date attr...
Benchmarking Pg Loader with input Large 5 Million...
Benchmarking Pg Loader with input Medium 100 Thousand...
Benchmarking Pg Loader with input NaiveDateTime attr...
Benchmarking Pg Loader with input Small 1 Thousand...
Benchmarking Pg Loader with input Time attr...
Benchmarking Pg Loader with input UUID attr...
##### With input Big 1 Million #####
Name ips average deviation median 99th %
Pg Loader 0.69 1.45 s ±2.35% 1.46 s 1.51 s
MySQL Loader 0.69 1.46 s ±3.14% 1.46 s 1.54 s
Comparison:
Pg Loader 0.69
MySQL Loader 0.69 - 1.00x slower
##### With input Date attr #####
Name ips average deviation median 99th %
Pg Loader 7.52 133.02 ms ±7.87% 130.86 ms 181.46 ms
MySQL Loader 7.49 133.56 ms ±7.31% 131.84 ms 175.11 ms
Comparison:
Pg Loader 7.52
MySQL Loader 7.49 - 1.00x slower
##### With input Large 5 Million #####
Name ips average deviation median 99th %
Pg Loader 0.129 7.78 s ±5.01% 7.78 s 8.17 s
MySQL Loader 0.128 7.79 s ±5.28% 7.79 s 8.20 s
Comparison:
Pg Loader 0.129
MySQL Loader 0.128 - 1.00x slower
##### With input Medium 100 Thousand #####
Name ips average deviation median 99th %
Pg Loader 7.62 131.28 ms ±8.64% 128.63 ms 177.42 ms
MySQL Loader 7.56 132.21 ms ±7.57% 130.16 ms 178.33 ms
Comparison:
Pg Loader 7.62
MySQL Loader 7.56 - 1.01x slower
##### With input NaiveDateTime attr #####
Name ips average deviation median 99th %
MySQL Loader 6.34 157.72 ms ±9.85% 156.54 ms 215.10 ms
Pg Loader 6.33 157.90 ms ±10.72% 157.03 ms 226.06 ms
Comparison:
MySQL Loader 6.34
Pg Loader 6.33 - 1.00x slower
##### With input Small 1 Thousand #####
Name ips average deviation median 99th %
Pg Loader 899.04 1.11 ms ±42.87% 1.02 ms 2.60 ms
MySQL Loader 866.55 1.15 ms ±50.35% 1.03 ms 3.26 ms
Comparison:
Pg Loader 899.04
MySQL Loader 866.55 - 1.04x slower
##### With input Time attr #####
Name ips average deviation median 99th %
MySQL Loader 6.33 158.01 ms ±8.56% 155.01 ms 220.64 ms
Pg Loader 6.31 158.38 ms ±8.66% 156.07 ms 223.84 ms
Comparison:
MySQL Loader 6.33
Pg Loader 6.31 - 1.00x slower
##### With input UUID attr #####
Name ips average deviation median 99th %
MySQL Loader 3.98 251.41 ms ±5.13% 249.64 ms 296.46 ms
Pg Loader 3.95 253.46 ms ±5.65% 251.78 ms 309.11 ms
Comparison:
MySQL Loader 3.98
Pg Loader 3.95 - 1.01x slower
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment