> I have seen a lot where joins are essentially done at the application level in loops in the relatively slow language

That's an indication of poor programming skills rather than programming language being "slow".