I Wrote the Same 25 Million Rows 17 Ways. The Fastest Layout Was 57× Quicker Than the Slowest.

Byali

Aug 29, 2026 #python

I Wrote the Same 25 Million Rows 17 Ways. The Fastest Layout Was 57× Quicker Than the Slowest.

Row group size, codec, dictionary encoding and sort order, measured — plus the one-line query mistake that undoes all of it.

Continue reading on Medium »

I Wrote the Same 25 Million Rows 17 Ways. The Fastest Layout Was 57× Quicker Than the Slowest. Row group size, codec, dictionary encoding and sort order, measured — plus the one-line query mistake that undoes all of it.Continue reading on Medium » Read More Python on Medium

#python

By ali

Python

Slowly Changing Dimensions Deep Dive: SCD Types 0–6 With Cross-Dialect SQL

Aug 30, 2026 ali

Python

Stop Regenerating from Scratch: How We Slashed Multi-Agent Token Consumption and Latency by 5x

Aug 30, 2026 ali

Python

One Sorts the List, One Sorts a Copy: sort() vs sorted() in 3 Rounds

Aug 30, 2026 ali

M	T	W	T	F	S	S
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30
31

I Wrote the Same 25 Million Rows 17 Ways. The Fastest Layout Was 57× Quicker Than the Slowest.

Byali

By ali

Related Post

Slowly Changing Dimensions Deep Dive: SCD Types 0–6 With Cross-Dialect SQL

Stop Regenerating from Scratch: How We Slashed Multi-Agent Token Consumption and Latency by 5x

One Sorts the List, One Sorts a Copy: sort() vs sorted() in 3 Rounds

Leave a Reply Cancel reply

You missed

Best CD rates today, Saturday, August 29, 2026: Lock in up to 4.30% APY with a 16- or 18-month CD

When will mortgage rates go down? Or maybe they’re poised to move higher.

Fabio Quartararo knew Yamaha engine was going to blow up in tough Aragon GP sprint

HDFC Bank CEO Jagdishan to step down in October as governance pressures mount

Alicloud.my.id