Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

Can anyone suggest a suitable setting for the Database Cache in FM Server 7?

According to Filemaker in their "FM Server Best Practices" document, the Database Cache should (as a starting point) be set to 5% of the total size of databases hosted. As the databases hosted on my Server are approximately 65MB at the moment, I set the cache to 5MB. However, whatever I set the cache size to, I seem to be getting 100% cache hits all the time. I've tried it at 200MB, at 100MB at 50MB and all sorts of others, but none seem to change things.

Any advice?

Thanks

Posted

My rule: Under OS X, set it as large as possible, unless you have a specific reason to do otherwise.

FileMaker made some changes (I think in 7v3) that prevent you from setting it too large in most circumstances. E.g. on a system with 1024mb, the maximum cache size is about 200mb, which leave 800+ mb for OSX and other processes, so you are in no danger of starving the OS for ram.

A 100% cache hit ratio is a good thing.

This point has been argued before, and I believe there is a belief that you want a 95% cache hit ratio, but I've never heard a cogent reason why this could be any better than a 100% cache hit ratio, all things being equal.

This topic is 6811 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.