Benchmark
Benchmark run from 2024-05-04 10:39:52.658755Z UTC
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 |
Benchmark suite executing with the following configuration:
| :time | 5 s |
|---|---|
| :parallel | 1 |
| :warmup | 2 s |
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 |