Benchmark

Benchmark run from 2024-05-04 10:49:35.563150Z 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: Changeset

Run Time

Name	IPS	Average	Devitation	Median	99th %
SQLite3 Insert	26.72 K	37.42 µs	±89.66%	32.88 µs	74.21 µs
Pg Insert	9.65 K	103.63 µs	±68.38%	102.75 µs	177.39 µs
MyXQL Insert	5.49 K	182.25 µs	±49.23%	182.33 µs	233.08 µs

Run Time Comparison

Name	IPS	Slower
SQLite3 Insert	26.72 K
Pg Insert	9.65 K	2.77x
MyXQL Insert	5.49 K	4.87x

Input: Struct

Run Time

Name	IPS	Average	Devitation	Median	99th %
SQLite3 Insert	26.71 K	37.44 µs	±87.15%	32.92 µs	70.50 µs
Pg Insert	9.34 K	107.08 µs	±13.80%	106.87 µs	132.46 µs
MyXQL Insert	5.67 K	176.45 µs	±70.69%	176.79 µs	234.70 µs

Run Time Comparison

Name	IPS	Slower
SQLite3 Insert	26.71 K
Pg Insert	9.34 K	2.86x
MyXQL Insert	5.67 K	4.71x