Thank you, Fokko. As soon as I finish the changes for the firmware (mainly LAN access – already working, security, automated device IDs and hopefully-if-possible OTA firmware update) , I will look into the mysql optimisations.
Also if anyone wants to help, I’m almost done with the dev server and I can provide access accounts there to change/test the environment in real time (data is simply cloned from the prod server).
Radu