to_sql.md

Benchmark

Benchmark run from 2024-05-04 10:48:53.108179Z 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: Complex Query 2 Joins

Run Time

Name	IPS	Average	Devitation	Median	99th %
Pg Query Builder	382.74 K	2.61 µs	±374.25%	2.38 µs	3.42 µs
SQLite3 Query Builder	374.17 K	2.67 µs	±382.43%	2.46 µs	3.42 µs
MyXQL Query Builder	360.95 K	2.77 µs	±360.52%	2.54 µs	3.58 µs

Run Time Comparison

Name	IPS	Slower
Pg Query Builder	382.74 K
SQLite3 Query Builder	374.17 K	1.02x
MyXQL Query Builder	360.95 K	1.06x

Input: Complex Query 4 Joins

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	342.45 K	2.92 µs	±313.75%	2.67 µs	4.08 µs
Pg Query Builder	340.76 K	2.93 µs	±350.68%	2.71 µs	3.88 µs
SQLite3 Query Builder	336.08 K	2.98 µs	±328.89%	2.79 µs	3.88 µs

Run Time Comparison

Name	IPS	Slower
MyXQL Query Builder	342.45 K
Pg Query Builder	340.76 K	1.0x
SQLite3 Query Builder	336.08 K	1.02x

Input: Fetch First Registry

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	752.12 K	1.33 µs	±868.39%	1.17 µs	1.63 µs
Pg Query Builder	721.56 K	1.39 µs	±820.83%	1.25 µs	1.67 µs
SQLite3 Query Builder	703.84 K	1.42 µs	±817.39%	1.29 µs	1.71 µs

Run Time Comparison

Name	IPS	Slower
MyXQL Query Builder	752.12 K
Pg Query Builder	721.56 K	1.04x
SQLite3 Query Builder	703.84 K	1.07x

Input: Fetch Last Registry

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	731.59 K	1.37 µs	±795.20%	1.21 µs	1.71 µs
Pg Query Builder	716.25 K	1.40 µs	±814.43%	1.25 µs	1.67 µs
SQLite3 Query Builder	707.98 K	1.41 µs	±839.02%	1.25 µs	1.67 µs

Run Time Comparison

Name	IPS	Slower
MyXQL Query Builder	731.59 K
Pg Query Builder	716.25 K	1.02x
SQLite3 Query Builder	707.98 K	1.03x

Input: Ordinary Delete All

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	1.34 M	747.69 ns	±2442.90%	666 ns	917 ns
Pg Query Builder	1.32 M	758.40 ns	±2490.71%	667 ns	875 ns
SQLite3 Query Builder	1.31 M	762.71 ns	±2451.66%	667 ns	875 ns

Run Time Comparison

Name	IPS	Slower
MyXQL Query Builder	1.34 M
Pg Query Builder	1.32 M	1.01x
SQLite3 Query Builder	1.31 M	1.02x

Input: Ordinary Order By

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	742.88 K	1.35 µs	±918.40%	1.17 µs	1.67 µs
Pg Query Builder	729.59 K	1.37 µs	±913.47%	1.21 µs	1.58 µs
SQLite3 Query Builder	721.11 K	1.39 µs	±918.31%	1.21 µs	1.58 µs

Run Time Comparison

Name	IPS	Slower
MyXQL Query Builder	742.88 K
Pg Query Builder	729.59 K	1.02x
SQLite3 Query Builder	721.11 K	1.03x

Input: Ordinary Select All

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	838.25 K	1.19 µs	±1122.54%	1.04 µs	1.46 µs
Pg Query Builder	822.53 K	1.22 µs	±1179.00%	1.08 µs	1.38 µs
SQLite3 Query Builder	809.74 K	1.23 µs	±1198.22%	1.08 µs	1.42 µs

Run Time Comparison

Name	IPS	Slower
MyXQL Query Builder	838.25 K
Pg Query Builder	822.53 K	1.02x
SQLite3 Query Builder	809.74 K	1.04x

Input: Ordinary Update All

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	1.03 M	971.15 ns	±1801.37%	834 ns	1167 ns
Pg Query Builder	1.01 M	990.87 ns	±1533.42%	875 ns	1125 ns
SQLite3 Query Builder	1.00 M	999.05 ns	±1416.75%	875 ns	1166 ns

Run Time Comparison

Name	IPS	Slower
MyXQL Query Builder	1.03 M
Pg Query Builder	1.01 M	1.02x
SQLite3 Query Builder	1.00 M	1.03x

Input: Ordinary Where

Run Time

Name	IPS	Average	Devitation	Median	99th %
MyXQL Query Builder	579.57 K	1.73 µs	±668.48%	1.54 µs	2.17 µs
Pg Query Builder	574.41 K	1.74 µs	±631.02%	1.58 µs	2.13 µs
SQLite3 Query Builder	568.60 K	1.76 µs	±635.93%	1.62 µs	2.13 µs

Run Time Comparison

Name	IPS	Slower
MyXQL Query Builder	579.57 K
Pg Query Builder	574.41 K	1.01x
SQLite3 Query Builder	568.60 K	1.02x