Solved

Filemaker Server slow with PHP on new server

Posted on 2013-05-14
3
934 Views
Last Modified: 2013-05-23
I'm looking for help with a persistent issue that I can't seem to find an answer to. I have a client that is looking to use an existing set of PHP pages to talk to their FileMaker database. The PHP pages are in use in other situations with the same database and work fine there.

They've got it setup on a new fast server running FM Server 11 deployed for single-machine web publishing, with IIS and an SSL area, but the response time for database related interactions is very slow, 20-30 seconds per page. Even when I open a browser on the desktop of the server and connect to the php pages using http://localhost, it's slow. In fact, though I didn't time it, on the server's desktop if felt even slower than opening it remotely from my own computer.

I recently installed the same PHP pages with FM Server 9, on an old G4 Mac Mini the other day for another client and it was far more responsive than this much newer and faster machine (I know there are OS differences, but still…).

It's definitely slower than on other Windows Server 2008 installs that I've seen but I'm just don't know Windows and IIS well enough to diagnose it. And it might be an FM Server issue but I don't know why that would be, especially when opening to localhost on the same machine... Their local tech who setup the server, IIS and SSL doesn't have any ideas and neither do I at this point.

I'm looking for insight and suggestions from anyone with experience using Windows Server, IIS and Filemaker Server.
0
Comment
Question by:Will Loving
  • 2
3 Comments
 
LVL 11

Expert Comment

by:Andrew Angell
ID: 39166132
Direct connections to FileMaker in general are always slow, which is why they introduced External SQL Sources and FM themselves recommend you use that instead of connecting directly.  That said, it shouldn't be taking 20 - 30 seconds with just a single visitor on the site.  That's the thing, though, as soon as you get 2,3,4+ visitors all clicking around quering for categories, product details, etc. it will bring your server to its knees no matter how big and powerful it is.  So honestly, I'd recommend going that route and skipping this anyway.

If you want to stick with what you're doing, though, the first thing I would look into is to make sure all of the ports that need to be open are open on all routers and firewalls, including the Windows Firewall.  Here's a good resource for that:  http://help.filemaker.com/app/answers/detail/a_id/6427/~/filemaker-server-and-filemaker-server-advanced-port-numbers
0
 
LVL 24

Accepted Solution

by:
Will Loving earned 0 total points
ID: 39177503
The primary issue turned out to be that the default page in IIS was not set to index.php. A possibly secondary cause is that the IP address for the database was set to localhost. This does work, but we changed it to 127.0.0.1 just to be more explicit. I have not tested to see whether the localhost 127.0.0.1 significantly affects things but the first change definitely did.
0
 
LVL 24

Author Closing Comment

by:Will Loving
ID: 39190265
Solution was found through direct troubleshooting rather than the one answer I received.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now