1 Reply Latest reply on Nov 30, 2010 11:00 AM by philmodjunk

    Server Performance Enhancement

    DennisNolan

      Title

      Server Performance Enhancement

      Your post

      I need a little feedback regarding performance of our FMP server. We're running FMP 11 trial version on a new Mac Mini server with 8GB of ram memory. This server handles DNS, OD and basic file sharing. The two internal mirrored drives host the database composed of 84 database files. The database was originally created in FMP5 and ran on a Windows 2003 server box without any problems. We have 5 users accessing the server. 

      Currently when users access the initial database file, everyone's  cursor changes to the spinning beach ball for about 35 secs. Usually that's the longest delay. Has anyone experience these types of delays when working with this many database files. I'm sure some of the timeouts occur because of all the linked files associated with the first file.

      Would running this on a dedicated Mac Mini improve this performance or is the number of database files the bottleneck here? Would a SSD drive improve this situatiion?

      Does FMP 11 server have that much additional overhead that a modern processor with twice the ram of the original Windows server running FMP 5 can't deliver the same user performance?

      Thanks to all who respond.

        • 1. Re: Server Performance Enhancement
          philmodjunk

          Before you make additional hardware investments, you need to analyze your system for possible database changes that may be needed to speed up performance.

          Open Manage | External Datasources and examine the external datasource references. It's very likely that you have some that need to be cleaned up as Version 5 tended to create very cluttered external data source references (and then didn't let you edit them!).

          Check for scripts that run when the file is opened as that could explain your spinning beachball that holds everybody up each time someone opens the initial file.

          For both of these tasks, a copy of FileMaker Advanced with its Database Design Report and Script Debugger will be invaluable.