Hack to extend depth of get...Path queries before MySQL join limit is hit (for longer paths, split query into fetching id and then loading object).

Cache SFTP paths to speed these path queries up and limit the number of really long ones that will be typically executed.