2 Replies Latest reply on Apr 10, 2013 2:51 PM by philmodjunk

    Extremely slowness

    bcancilla

      Summary

      Extremely slowness

      Product

      FileMaker Server

      Version

      11.v5

      Operating system version

      Windows Server 2008

      Description of the issue

      When users are runnin reports, the system is extremely slow.  It is sorting records for over an  hour or more.

      We have up to 75 users hitting the database at certain times.

        • 1. Re: Extremely slowness
          Fred(CH)

                

               Hi bcancilla,

               The slowness of sorting records is generally due to the sorted Field Options in Manage > Database… menu, Fields tab : 

               When a field is calculated AND if the calculation is not stored (always re-calculated), that defined in "Other option" tab, sorting on it can be very slow.

               Of course, it is also depending of the number of records, the fact that your file is hosted, the network flow and can vary by a lot of other factors...

               Anyways, you can really increase performence by setting your fields options carefully.

               Bye, Fred

          • 2. Re: Extremely slowness
            philmodjunk

                 Sorting on a field from a related table can also slow the sort down. Also a normal data field with no index will sort much more slowly than if indexing were turned on for that field, I believe.