Just to chime in – increasing memory limit will solve to a degree, but we had an enormous site and even if we maxed out the memory limit we still had issues.
A better solution would be to limit the lookup so the server does not max out. Hopefully Elliot and the ACF team will consider adding some functionality to address this
Thanks