Here : speed is OK because server are local
But with external SQL server : take long time

I have 4 server on the same network, on public and one internal. 2 for production + 2 for prepoduction , proxy for high availability, SQL server on same network but another server.

The 5.X is the preprod for testing version : the link to the DB server are same all other configuration are same. And BD is just some week old.

For 5.X : i'm connected directly by internal VPN : less network
For 3.X : external + my own VPN (AirVPN) +

Survey listing on 5.X : 20.48 s
Same survey listing on 3.X 2.56s

… it's REALLY unusuable

Idea one : Use a static array for template (like we do for Survey)

Idea : better action : move some needed action to findByPk only (when we get THE survey)
See related