Solved

Filemaker Server slow with PHP on new server

Posted on 2013-05-14
3
938 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 25

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 25

Author Closing Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

773 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