The best connection is a solid mechanical connection, in a proper joint solder should be seen more as a glue and sealant to maintain said mechanical connection and not as a conductor. Also, I don't see any reason to go with exotic solder brands, you're paying mostly for the name. With research...