to_sql.md

Benchmark

Benchmark run from 2021-03-24 02:02:16.278354Z UTC

System

Benchmark suite executing on the following system:

Operating System	Linux
CPU Information	AMD Ryzen 7 PRO 4750U with Radeon Graphics
Number of Available Cores	16
Available Memory	14.92 GB
Elixir Version	1.11.3
Erlang Version	23.2.6

Configuration

Benchmark suite executing with the following configuration:

:time	5 s
:parallel	1
:warmup	2 s

Statistics

Input: Complex Query 2 Joins

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	105.28 K	9.50 μs	±116.92%	8.66 μs	24.79 μs
Pg Query Builder	96.97 K	10.31 μs	±220.90%	8.66 μs	26.75 μs
SQLite3 Query Builder	90.46 K	11.05 μs	±204.34%	8.66 μs	39.53 μs

Comparison

Name	IPS	Slower
MyXQL Query Builder	105.28 K
Pg Query Builder	96.97 K	1.09x
SQLite3 Query Builder	90.46 K	1.16x

---

Input: Complex Query 4 Joins

Run Time

Name	IPS	Average	Devitation	Median	99th %
Pg Query Builder	100.25 K	9.97 μs	±92.25%	9.15 μs	23.68 μs
MyXQL Query Builder	98.47 K	10.16 μs	±88.64%	9.22 μs	28.70 μs
SQLite3 Query Builder	90.40 K	11.06 μs	±117.48%	9.22 μs	38.69 μs

Comparison

Name	IPS	Slower
Pg Query Builder	100.25 K
MyXQL Query Builder	98.47 K	1.02x
SQLite3 Query Builder	90.40 K	1.11x

---

Input: Fetch First Registry

Run Time

Name	IPS	Average	Devitation	Median	99th %
Pg Query Builder	173.31 K	5.77 μs	±389.85%	4.47 μs	20.18 μs
MyXQL Query Builder	173.06 K	5.78 μs	±411.02%	4.82 μs	16.20 μs
SQLite3 Query Builder	167.17 K	5.98 μs	±420.59%	4.82 μs	19.42 μs

Comparison

Name	IPS	Slower
Pg Query Builder	173.31 K
MyXQL Query Builder	173.06 K	1.0x
SQLite3 Query Builder	167.17 K	1.04x

---

Input: Fetch Last Registry

Run Time

Name	IPS	Average	Devitation	Median	99th %
Pg Query Builder	177.36 K	5.64 μs	±446.37%	4.47 μs	17.67 μs
SQLite3 Query Builder	169.74 K	5.89 μs	±394.73%	4.82 μs	18.16 μs
MyXQL Query Builder	162.83 K	6.14 μs	±383.32%	4.82 μs	22.14 μs

Comparison

Name	IPS	Slower
Pg Query Builder	177.36 K
SQLite3 Query Builder	169.74 K	1.04x
MyXQL Query Builder	162.83 K	1.09x

---

Input: Ordinary Delete All

Run Time

Name	IPS	Average	Devitation	Median	99th %
Pg Query Builder	335.81 K	2.98 μs	±775.40%	2.03 μs	9.43 μs
SQLite3 Query Builder	325.92 K	3.07 μs	±948.36%	2.02 μs	8.31 μs
MyXQL Query Builder	301.67 K	3.31 μs	±832.06%	2.03 μs	11.59 μs

Comparison

Name	IPS	Slower
Pg Query Builder	335.81 K
SQLite3 Query Builder	325.92 K	1.03x
MyXQL Query Builder	301.67 K	1.11x

---

Input: Ordinary Order By

Run Time

Name	IPS	Average	Devitation	Median	99th %
Pg Query Builder	186.48 K	5.36 μs	±400.39%	4.40 μs	17.81 μs
MyXQL Query Builder	182.02 K	5.49 μs	±402.64%	4.40 μs	17.39 μs
SQLite3 Query Builder	172.19 K	5.81 μs	±427.38%	4.47 μs	21.44 μs

Comparison

Name	IPS	Slower
Pg Query Builder	186.48 K
MyXQL Query Builder	182.02 K	1.02x
SQLite3 Query Builder	172.19 K	1.08x

---

Input: Ordinary Select All

Run Time

Name	IPS	Average	Devitation	Median	99th %
Pg Query Builder	200.19 K	5.00 μs	±657.77%	3.49 μs	14.88 μs
SQLite3 Query Builder	199.77 K	5.01 μs	±698.35%	3.49 μs	13.90 μs
MyXQL Query Builder	191.70 K	5.22 μs	±601.95%	3.56 μs	16.06 μs

Comparison

Name	IPS	Slower
Pg Query Builder	200.19 K
SQLite3 Query Builder	199.77 K	1.0x
MyXQL Query Builder	191.70 K	1.04x

---

Input: Ordinary Update All

Run Time

Name	IPS	Average	Devitation	Median	99th %
SQLite3 Query Builder	263.35 K	3.80 μs	±1304.70%	2.86 μs	10.13 μs
MyXQL Query Builder	260.96 K	3.83 μs	±760.59%	2.86 μs	10.20 μs
Pg Query Builder	249.05 K	4.02 μs	±827.04%	2.86 μs	12.99 μs

Comparison

Name	IPS	Slower
SQLite3 Query Builder	263.35 K
MyXQL Query Builder	260.96 K	1.01x
Pg Query Builder	249.05 K	1.06x

---

Input: Ordinary Where

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	162.26 K	6.16 μs	±343.86%	5.31 μs	17.74 μs
SQLite3 Query Builder	159.31 K	6.28 μs	±305.50%	5.38 μs	19.35 μs
Pg Query Builder	154.28 K	6.48 μs	±355.38%	5.45 μs	20.04 μs

Comparison

Name	IPS	Slower
MyXQL Query Builder	162.26 K
SQLite3 Query Builder	159.31 K	1.02x
Pg Query Builder	154.28 K	1.05x

---