[–] cjonas 6mo ago ↗ Same query solved in duckdb instead (generated by claude). I wasn't able to run on the full dataset due to an encoding issue I didn't feel like solving... but with everything up until 2001, it returns seconds on my M4 MBP.https://gist.github.com/ChuckJonas/4ffb0743de0c20a61394a6b95...
1 comment
[ 2.7 ms ] story [ 11.4 ms ] threadhttps://gist.github.com/ChuckJonas/4ffb0743de0c20a61394a6b95...