I have a LAMP hosted MySQL db and can have FMS hosted files access it using ESS from either Windows Machine using public domain ODBC drivers, or run FMS on Mac (with plenty of power) using Actual's driver.
Other things being equal, how does the performance compare in the two setups?
fwiw assume the two dbs are
1 on the same LAN
2 in separate locations say 30ms ping time apart, with plenty of bandwidth