Recently I got asked, what the best way to do a join between two large lists, into another list was? I always tend to answer that question with: it depends. Just like any other algorithm, there is no silver bullet. It is a trade off between CPU and memory utilisation. Sometimes, we do have to think about these things (this is code in c++ on a device with scarce resources, to say the least).
Read More