How does ESS and multiple FMS installs change the processing load on each server. I have not tested it yet, but is it any benefit to have certain tables and scripts running on separate servers. Will each server process its own table data or is everything passed onto the primary server to process.
It seems on first look everything is done on the primary server the user is connected to.
As an extreme example lets say you have a light weight dual core FMS with a few simple tables and an ESS FM database hosted on a decent 12 core FMS machine with a lot of records and calc fields and relationships. If you have a filtered and sorted portal or a find or other CPU intense task to be done with the larger file records will it be processed on the 12 core and the result returned to the dual core or will the dual core need to do all the heavy lifting?