Jump to content

Speed up Filemaker Database over internet


This topic is 3349 days old. Please don't post here. Open a new topic instead.

Should I?  

3 members have voted

  1. 1. Should I upgrade to the mac mini?

    • Yes
      0
    • No
      3


Recommended Posts

We have Filemaker Pro 10 Server running on a Mac Pro running snow leopard. On our LAN the speed is fine. We share the file over the web and its painfully slow. We have a 10meg leased line, so its 10meg up and 10meg down(uncontended).

The filemaker pro database file is now 500mb.

Does anyone have any advice?

I have been told to upgrade to FM12 which I plan to do, but is there anything else I can try.

Link to comment
Share on other sites

Minimize your use of:

summary fields

list views

sorting

sorted portals and relationships

non-native graphics on layouts

unstored calcs

lists that use filtered relationships or that display a second field while storing a key

- John

 

 

Thanks John, unfortunately my database uses all of the above. What you have above is everything that makes FM a viable option.

 

We are moving from FMP 10 - 12 this week to make use of 64 bit processing.

 

Looking to maybe update the Mac Pro 2GHZ Dual Core Zeon to something a bit newer. Does anyone think thats a good idea? Mac Mini i7?

Link to comment
Share on other sites

To be honest, if your using all the listed options above and are having speed issues, hardware will probably not make a huge difference.  WAN speed optimization always gets a larger boost from database optimization over hardware improvements in my experience.

  • Like 1
Link to comment
Share on other sites

  • 3 weeks later...

I agree with Russell, i am trying to sort out the same issue and upgrading to the newest and powerfull platform (FileMaker Server 12 Advanced running on Mac Pro Server medio 2010) did not help at all.

I wonder if anyone in the community could come up with a fair tutorial on what could be and what could not be expected from filemaker pro platform, so people dont run into building features that will just not work as expected when they "leave home".

I could suggest 2 artcles on the web that look interesting in regards to this issue:

1) Solving Performance Emergencies with FileMaker Server, Brian Dunning: http://www.briandunning.com/browse/browse0110.shtml

2) Finding the Bottleneck, Honza Koudelka:http://fmbench.com/bottleneck (this one is selling some plugin that did not work for me, but in general offers an interesting way of thinking on the subject).

Link to comment
Share on other sites

If you want to find out if your solution will work (realistically) over WAN then develop on a network with your network connection restricted to 10-20Mbps connection to the server.

Link to comment
Share on other sites

  • 2 years later...

If you want to find out if your solution will work (realistically) over WAN then develop on a network with your network connection restricted to 10-20Mbps connection to the server.

 

While that's a start, you'd also need to find a way to restrict latency from sub-1ms LAN times to the 15-40ms (Excellent), 50-70ms (Acceptable), >80ms (tragic) ping times over a WAN.  Theres also no way (at least that I know of) to simulate loss and fluctuating ping/latency times that are often symptomatic of operating on a WAN.

 

In my experience, network latency has a huge part to due with the slow performance of FMP over a LAN.  The reason I say that is because I've used FMP over a full 100Mbps connection on both client and server-side and it's still been abhorrently slow when compared to even a 100BaseT LAN connection.

  • Like 1
Link to comment
Share on other sites

This topic is 3349 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.