DoltLite 0.50.0

DoltLite Beta

DoltLite Beta means four things:

1. Storage format stability
2. SQL compatibility
3. Full version control
4. Production performance

Read the release blog for details.

There are no code changes from 0.11.57.

Benchmark / int-keys (100K rows, Linux x64)

File-Backed

Reads

Test	SQLite (us)	DoltLite (us)	Multiplier
oltp_point_select	52,041	33,401	0.64
oltp_range_select	12,907	11,061	0.86
oltp_sum_range	12,214	11,065	0.91
oltp_order_range	2,745	2,606	0.95
oltp_distinct_range	3,549	3,502	0.99
oltp_index_scan	6,687	5,606	0.84
select_random_points	13,247	11,523	0.87
select_random_ranges	5,685	4,373	0.77
covering_index_scan	6,761	4,742	0.70
groupby_scan	28,053	28,427	1.01
index_join	7,108	8,368	1.18
index_join_scan	3,241	4,278	1.32
types_table_scan	972,507	1,044,309	1.07
table_scan	1,127,990	1,167,377	1.03
oltp_read_only	138,314	116,519	0.84
Average			0.93

Writes

Test	SQLite (us)	DoltLite (us)	Multiplier
oltp_bulk_insert	161,332	220,347	1.37
oltp_insert	18,254	25,647	1.41
oltp_update_index	60,640	90,850	1.50
oltp_update_non_index	42,562	55,186	1.30
oltp_delete_insert	50,756	72,070	1.42
oltp_write_only	30,289	46,376	1.53
types_delete_insert	29,521	35,983	1.22
oltp_read_write	72,979	101,812	1.40
Average			1.39

100000 rows, median of 5 paired invocations per test; autocommit writes use 9, workload-only timing via host monotonic clock when available.