Benchmark

Benchmark run from 2024-05-04 10:39:52.658755Z UTC

System #

Benchmark suite executing on the following system:

Operating System	macOS
CPU Information	Apple M3 Max
Number of Available Cores	16
Available Memory	128 GB
Elixir Version	1.16.2
Erlang Version	26.2.4

Configuration #

Benchmark suite executing with the following configuration:

:time	5 s
:parallel	1
:warmup	2 s

Statistics #

Input: Big 1 Million

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Loader	1.90	526.95 ms	±7.52%	520.79 ms	590.85 ms
Pg Loader	1.89	527.72 ms	±7.17%	523.29 ms	589.90 ms
SQLite3 Loader	1.89	529.12 ms	±7.67%	522.49 ms	594.22 ms

Run Time Comparison

Name	IPS	Slower
MyXQL Loader	1.90
Pg Loader	1.89	1.0x
SQLite3 Loader	1.89	1.0x

Input: Date attr

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Loader	26.37	37.93 ms	±7.64%	37.53 ms	48.13 ms
Pg Loader	25.98	38.49 ms	±7.63%	38.31 ms	48.20 ms
SQLite3 Loader	25.91	38.59 ms	±7.51%	38.46 ms	48.29 ms

Run Time Comparison

Name	IPS	Slower
MyXQL Loader	26.37
Pg Loader	25.98	1.01x
SQLite3 Loader	25.91	1.02x

Input: Medium 100 Thousand

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Loader	26.27	38.07 ms	±5.01%	38.36 ms	42.73 ms
SQLite3 Loader	25.64	39.01 ms	±5.25%	39.42 ms	43.28 ms
Pg Loader	25.44	39.31 ms	±6.97%	39.50 ms	49.12 ms

Run Time Comparison

Name	IPS	Slower
MyXQL Loader	26.27
SQLite3 Loader	25.64	1.02x
Pg Loader	25.44	1.03x

Input: Small 1 Thousand

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Loader	2.95 K	339.32 µs	±13.05%	330.33 µs	493.99 µs
Pg Loader	2.92 K	342.75 µs	±13.24%	332.17 µs	499.14 µs
SQLite3 Loader	2.91 K	343.63 µs	±12.64%	330.21 µs	495.04 µs

Run Time Comparison

Name	IPS	Slower
MyXQL Loader	2.95 K
Pg Loader	2.92 K	1.01x
SQLite3 Loader	2.91 K	1.01x

Input: Time attr

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Loader	21.75	45.98 ms	±11.17%	45.25 ms	61.90 ms
Pg Loader	21.43	46.67 ms	±10.90%	45.76 ms	61.66 ms
SQLite3 Loader	20.72	48.26 ms	±9.03%	48.63 ms	62.19 ms

Run Time Comparison

Name	IPS	Slower
MyXQL Loader	21.75
Pg Loader	21.43	1.01x
SQLite3 Loader	20.72	1.05x

Input: UUID attr

Run Time

Name	IPS	Average	Devitation	Median	99th %
SQLite3 Loader	23.23	43.06 ms	±8.19%	41.64 ms	51.14 ms
MyXQL Loader	15.19	65.81 ms	±7.56%	63.25 ms	76.27 ms
Pg Loader	14.89	67.14 ms	±7.74%	64.12 ms	80.65 ms

Run Time Comparison

Name	IPS	Slower
SQLite3 Loader	23.23
MyXQL Loader	15.19	1.53x
Pg Loader	14.89	1.56x