2 Replies Latest reply on Dec 23, 2009 1:46 PM by Steve Wright

    Filemaker Cache

    Steve Wright

      Title

      Filemaker Cache

      Post

      Are there any documents which go into detail on the cache settings in filemaker.

      Such as the effects it has over peer to peer networking, what size recommendations based on database sizes etc etc

       

      It seems to be covered in its very basic form wherever I look.   

       

      Such as 

      1. For FileMaker Pro, increasing the cache size may help but there is a trade off as explained in step 8.  This is set in Preferences.
      2. For FileMaker Server: Turn the statistic logging on and make sure on average that the % cache hit ratio is somewhere between 95% to 100 %.  If it's always hitting 100 % regardless of how many users and files are open then too much memory is allocated and the RAM cache for FileMaker Server should be set lower than the current setting.  If it's hitting less than 95 % then you will want to raise the database cache size.  The trade off in increasing the cache size whether it is in FileMaker Server or FileMaker Pro, is that the larger the cache size the less is written to disk until the cache is flushed.  This means if the application crashes then it can cause a loss of data as big as your cache setting.

       

      We do not use FM Server, so cannot check the cache hit ratio.

      Ive yet to find any specific recommended settings other than in filemaker it states 8mb is default, seems very low by todays standards.

      Setting to 256mb seems to have very little effect, even with large data sets

       

      What benefits does a larger cache provide in filemaker ? What does it actually affect ?

       

      Its something I have not really put much thought into in the past, but as our clients data sets increase in size, I thought it best to try and find out more info. 

       

      Thanks in advance  

       

        • 1. Re: Filemaker Cache
          mrvodka
            

          Your users will work in cache until the data in flushed to the disk. The higher the cache the fast it should technically be but that it why you increase the chance of losing data when it hasnt been written to the disk if you crash.

           

          I would suggest you try using a copy of FMS to see if it helps. Download the trial copy. FMS is optimized for these kinds of scenarios and should handle the data much better than a box set up as a host in a peer 2 peer.

          • 2. Re: Filemaker Cache
            Steve Wright
              

            I just renewed my subscription to technet, so I can now play around with the developer version of FMS

            I havent bothered with technet for about a year now.

             

            I understand how the cache should work, but it seems to make no difference at all between 8mb and 256 mb perhaps its just the way im manipulating the data etc.

            Anyway, ill experiment with the cache hit rate with server, maybe that will give me an idea whats going on under the hood a little more.