DoltLite 0.50.1
·
444 commits
to master
since this release
.NET binding support via NuGet.
.NET
- Added
DoltHub.Doltlite, integrating DoltLite with SQLitePCLRaw,Microsoft.Data.Sqlite.Core, EF Core, and Dapper. - Added cross-platform packages and automated NuGet publishing.
Installer
- The curl installer now installs
doltlite.hwithout also installing the conflictingsqlite3.h.
Benchmark / int-keys (100K rows, Linux x64)
File-Backed
Reads
| Test | SQLite (us) | DoltLite (us) | Multiplier |
|---|---|---|---|
| oltp_point_select | 109,378 | 48,475 | 0.44 |
| oltp_range_select | 19,612 | 13,383 | 0.68 |
| oltp_sum_range | 18,587 | 12,770 | 0.69 |
| oltp_order_range | 3,538 | 3,053 | 0.86 |
| oltp_distinct_range | 4,652 | 4,130 | 0.89 |
| oltp_index_scan | 12,753 | 7,449 | 0.58 |
| select_random_points | 19,690 | 13,462 | 0.68 |
| select_random_ranges | 11,424 | 6,225 | 0.54 |
| covering_index_scan | 13,014 | 6,696 | 0.51 |
| groupby_scan | 33,755 | 33,740 | 1.00 |
| index_join | 10,576 | 9,685 | 0.92 |
| index_join_scan | 4,514 | 5,034 | 1.12 |
| types_table_scan | 1,128,569 | 1,152,594 | 1.02 |
| table_scan | 1,292,767 | 1,286,089 | 0.99 |
| oltp_read_only | 229,036 | 141,567 | 0.62 |
| Average | 0.77 |
Writes
| Test | SQLite (us) | DoltLite (us) | Multiplier |
|---|---|---|---|
| oltp_bulk_insert | 191,826 | 247,852 | 1.29 |
| oltp_insert | 21,891 | 32,053 | 1.46 |
| oltp_update_index | 79,512 | 103,655 | 1.30 |
| oltp_update_non_index | 58,374 | 67,064 | 1.15 |
| oltp_delete_insert | 67,983 | 82,048 | 1.21 |
| oltp_write_only | 44,997 | 54,929 | 1.22 |
| types_delete_insert | 40,523 | 42,850 | 1.06 |
| oltp_read_write | 90,679 | 115,203 | 1.27 |
| Average | 1.25 |
100000 rows, median of 5 paired invocations per test; autocommit writes use 9, workload-only timing via host monotonic clock when available.