Thank you for this. This is indeed where I actually used the technique. You do get dramatic speed up if you do it in SQL this is provable.
I chose to use python as an example here mainly because the SQL example would get very convoluted and be much less concise.
The main point was the general technique of moving back and forth between isomorphic types, but people are getting too involved with implementation details of python. Yeah it might(keyword) be slower, yeah it's more convoluted than a traditional list comprehension in python, but that is not the point.
Lesson learned: don't use arbitrary examples to prove a point. Use an example where all metrics are dramatically better.
I chose to use python as an example here mainly because the SQL example would get very convoluted and be much less concise.
The main point was the general technique of moving back and forth between isomorphic types, but people are getting too involved with implementation details of python. Yeah it might(keyword) be slower, yeah it's more convoluted than a traditional list comprehension in python, but that is not the point.
Lesson learned: don't use arbitrary examples to prove a point. Use an example where all metrics are dramatically better.