@steveguk
I found a pretty close solution for improve the performance, for me it’ll not work now because it’s only works with basic fields(acf).
Take a look if it work’s to your project.
This is the plugin to do this. https://hookturn.io/downloads/acf-custom-database-tables/