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