Solved

Filemaker Server slow with PHP on new server

Posted on 2013-05-14
3
955 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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 …
Suggested Courses

630 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