MySQL vs FM tables with PHP

[bcooney]

We're investigating redevelopment of a system that has a PHP front-end. Currently, PHP talks to our FM tables. However, response is slow and often users are shut out (20 users seems to be the max). We've read many threads that the WPE is the bottleneck.

So, we're thinking of moving the tables to MySQL

(at least those that interact with the website).

The big question is: Is it worth it? Will we see the response speed improvements that we hope for? Anyone live thru this and have pointers to share?

[bcooney]

Many views, but no experiences to share?

[xavier782]

We made a solution using FX.php that worked very well. Several hundred users at the same time had a good response time.

We used a single Xserve machine with FileMaker Server, 4GB memory and worked always very well.

Can you provide more information about your project or configuration?

Regards,

Xavier