A little background.

My FM 11 server is slow. Very slow. too many things going on on this poor machine at the same time.

* * * *

FM server has a huge load connecting to a MySQL external data source and going back and forth making native queries slow.

My question becomes:

Is there a way to load balance FileMaker server acroos 2 separate machines, in order for the one machine to run the SQL querries back and forth, while the other serves the native Filemaker databases? And than just have the 2 FM servers update each others records?

would that help removing the load from the "main" server?

I have already set up, in the past, a worker and master server. But that was for the web publishing engines and was for another situation altogether. That worked really well in alleviating another load. Would that be a possible solution?

The servers are Dual Quad Xeons, Server 2008 R2 x64 with 12 Gigs of RAM. So the server is definitely not underpowered... Could be a programming issue... But nonetheless... Before going that route, would like to see if load balancing the querries helps.

Thank you in advance for any assistance and/or suggestions.

Check out syncdec from WorldSync

Don't disregard the architecture that easily though...