ecto_sqlite3
An Ecto SQLite3 adapter.
Star
Fork
Watch
ecto_sqlite3 bench results to_sql.md
23 kB · 713 lines
Markdown
at binary_encoding

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