in order
sudo reflector --protocol https --verbose --latest 25 --sort rate --save /etc/pacman.d/mirrorlist
then
yay -Syyu
then
sudo eos-rankmirrors --verbose
then
yay -Syyu
this usually does the trick.
from A Complete Idiot's Guide To Endeavour OS Maintenance / Update / Upgrade