I've done a bit more research over the weekend.
I signed up for a trial account with
Triple8 and uploaded the three files there.
The speed when using the companies, contacts and projects layouts is fine. The calendar is another story altogether and I found it unusable. Haven't tried Invoices yet
I got to thinking about the new data separation model and opened SeedCodeComplete from a local file and SeedCodeData and SeedCodeMedia from the remote files. The performance with this arrangement is good.
Obviously the convoluted start sequence is less than ideal, I guess this could be scripted?? I think I'd still want to maintain IWP access which would mean maintaining a copy of the SeedCodeComplete file on the remote server as well.
At present I have to maintain a separate server (because FileMaker and Retrospect don't play nicely together on the same server, maybe this has changed now we're 2 versions along with both solutions??). If I upgrade the server (Mac Mini) and FMSA every 3 years I'm looking at A$3K to maintain 4-5 employees. I can run it remote for a third of that.
Are there any pitfalls I haven't considered?
Thanks
Rob