What I learned this week 09-26-2026
What I learned this week⌗
Software⌗
everyone now needs a shitty classifier?
- When a query groups on long, repeated strings, move the strings into a small dimension table with sorted, narrow integer keys. Aggregate on the keys, then join the strings back in at the very end. The query works as before, though on small fixed-width integers instead of variable-length text.