When I saw that Affinity Photo was getting a performance overhaul in 1.10, I thought maybe this issue had been fixed, but it still exists in the latest version:
Affinity Photo struggles to open PSD files with a lot of layers, I've attached an example file, it takes about 15 minutes to open.
It also doesn't really render correctly, many of the colours and effects are subtly off.
I know PSD is a difficult format, but Nomacs (another image viewer) is able to open this same PSD in less than a second and it renders correctly.
Nomacs uses a library called libqpsd to read PSD files, it looks like its free and open source, maybe AP should use it too: https://github.com/nomacs/libqpsd/tree/7472334d8e1ee9b37c18b9c7568ac91e5af4c9db
I really think it's important that Affinity Photo handle PSD files well, if you don't it will greatly hinder people moving across to this software from photoshop, right now its the only thing stopping me from moving across completely.
ProsperityMap.psd